in reply to Re^2: setting up mysql database name
in thread setting up mysql database name

I said 1K, not 1000. 1K is typically 1024 when you're in a programming context (its metric 1000 for everyone else).

If you use varchar(), it will only allocate the space it needs.

Replies are listed 'Best First'.
Re^4: setting up mysql database name
by Fletch (Bishop) on Dec 09, 2005 at 20:51 UTC
    If you use varchar(), it will only allocate teh space it needs.

    Or text columns which can handle much larger numbers of characters than varchar; although I want to say creating indexen on text columns had issues at one time (either didn't work or was much slower than indexing a varchar column).