make large text dynamic

[namtax]

i have started a music site, nearly finished, however i now want members to able to post lyrics for songs onto the website. Obviously the lyrics would be too large to fit into a database, and the formatting would obviously be lost as well. Just baffled to how I could achiebe this?

http://www.musicexplained.co.uk/

Any suggestions would be massively appreciated

[Newsgroup_User]

Obviously the lyrics would be too large to fit into a database...

Why would lyrics be too large to fit into a database, database hold
entire encyclopedias of text. You just have to understand your database
and what data types can hold how much text. Check out CLOBs and how
your database handles them.

[Dan_Bracuk]

Why do you say that the lyrics would be too large for a database? What sort of formatting do you think will be lost?

[namtax]

im using an access database...and presumed that you have a limit towards how many words you can have in a field. Am I wrong then?
When i say formatting i meant, where the line breaks are etc etc

Cheers

[Newsgroup_User]

im using an access database...and presumed that you have a limit towards
how many words you can have in a field. Am I wrong then?


When i say formatting i meant, where the line breaks are etc etc

Yes, there is a limit. IIRC the 'memo' field type can hold up to 2GB of
text, that would be a very long song I think. Now there are limitations
on using the memo field. One can not use it like a normal char or
varchar field in where clauses. So you should read up on it to
understand how to use it properly.

As for formating, do you mean ASCII formating or HTML formating. HTML
formating is just text, your store it in the field with the content.
ASCII formating as well, but with ASCII formating you will have to do
something for it to display properly in a browser, either convert to to
HTML on the fly or display inside of <pre></pre> OR <code></code> tags.

[namtax]

thanks for response Ian, yes following your initial response I checked up on the different data types access can maintain. I was completely unaware that the memo type allowed for large amounts of text, i thought it was only the text field that handled this form of data. Anyway I have sorted it now, so its all good