5 Replies Latest reply on Dec 20, 2006 10:17 AM by namtax

    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
        • 1. Re: make large text dynamic
          Level 7
          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.
          • 2. Re: make large text dynamic
            Dan Bracuk Level 5
            Why do you say that the lyrics would be too large for a database? What sort of formatting do you think will be lost?
            • 3. Re: make large text dynamic
              namtax Level 1
              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
              • 4. Re: make large text dynamic
                Level 7
                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.
                • 5. Re: make large text dynamic
                  namtax Level 1
                  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