SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Mar 2002
    Posts
    101
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need help to choose variable type using Mysql

    Hi I'd like to store in a Mysql database lyrics of songs.

    I couldn't find any script that works off the shelf.

    Firstly I'd like to know what format (mysql data type varchar) should I use to store lyrics (some lyrics may have about 1000 - 2000 words).

  2. #2
    Free me php klassicd's Avatar
    Join Date
    Sep 2001
    Location
    San Diego
    Posts
    509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would just use text.

    Its more than enough room but there isnt a middle ground here. Varchar(250) is too short, blob is crap, what else will you do?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •