On 8/8/06, Chris Blackwell <[EMAIL PROTECTED]> wrote:
I just tried changing the charset type on an existing table, and creating a new table with UTF8 columns (utf8/utf8_general_ci) and the schema shows the expected data
That depends on what you "expected" :)
"COLUMN_TYPE","CHARACTER_MAXIMUM_LENGTH","CHARACTER_OCTET_LENGTH" "varchar(10)",10,30 "varchar(45)",45,135
Right but that was what surprised me. If I say varchar(10) and UTF8, I *expected* a maxlength of 10 and an octet length of 30 or so. The problem here is that if you want to store 10 UTF8 characters, you have to essentially use varchar(40) to be safe. Not what I expected at all.
There is a bug on the MySQL site that describes exactly the problem you are reporting. http://bugs.mysql.com/bug.php?id=19236
I'm using 5.0.22 so I don't think that's the bug that affects me although I just tried char(9) and got a maxlength of 3... *sigh* I'll just make my columns about three times wider than I need :) -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
