[thelist] PHP & UTF-8

[Noah St. Amand]

Hi Hassan,

Hassan Schroeder wrote (12/20/05 4:12 PM):
> Doing something like `ALTER TABLE foo CHARSET=utf8` will NOT change
> the individual fields -- use SHOW CREATE TABLE foo to confirm. And
> don't ask me why it doesn't :-)
> 
> In the past, I've just used ALTER TABLE to change each text column
> *individually* as required.

Thanks for that. I also found this after I wrote the previous message:

<http://forums.mysql.com/read.php?103,26163,26163>

Which says:

-----
Note that the following command doesn't convert anything.

ALTER TABLE table_name DEFAULT CHARACTER SET = utf8;

If you want to convert the table definition and data of the existing 
table, do

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;
-----

Maybe useful in the future.

Cheers,
-- 
Noah St.Amand
tookish digital communication

phone: 613.549.5394
mobile: 613.453.5394
sms: sms at tookish.net
email: noah at tookish.net
web: http://www.tookish.net/