Thanks

But still I can't get the part where my column size totals to 560, but MySql complaining that I have exceeded 1024. Did I went anywhere wrong???

- Gana.


----------------------------------------------------------------------------------------------------
People are conversing... without posting their email or filling up their mail box. ~~1123871242499~~
roomity.com http://roomity.com/launch.jsp No sign up to read or search this Rich Internet App
----------------------------------------------------------------------------------------------------


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

javabuddy wrote:
What character set are you using? The default (latin1) is 1 byte per
char, but some different character sets are 2 or 3 bytes per char (for
example, unicode / UTF8 is 3 bytes). I can't find where this is
documented in the manual, but it is discussed slightly here:

http://dev.mysql.com/doc/mysql/en/char.html
http://dev.mysql.com/doc/mysql/en/charset-unicode.html


HTH,
Devananda vdv

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

javabuddy wrote:

Are you sure you've thought your index through correctly and considered how
MySQL will use it? What sort of query would such an index be useful for? In
most circumstance it makes little sense to index more than a prefix of a long
VARCHAR or TEXT field, and indexing nine fields at once will only make sense if
you use all nine in your query.

Maybe you want a FULLTEXT index?

--
Keith Ivey <keith (AT) smokefreedc (DOT) org>
Smokefree DC
http://www.smokefreedc.org
Washington, DC

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw