[thelist] PHP & UTF-8

Hassan Schroeder hassan at webtuitive.com
Tue Dec 20 15:12:56 CST 2005

Noah St. Amand wrote:

> One thing that may be relevant -- the collation throughout the database 
> is "latin1_swedish_ci" -- I've tried to change it to "utf8_general_ci", 
> but I have been unable to. This appears to be a common problem (I run 
> the "alter" statement on the table and nothing happens). Do you think 
> that this could be the cause of my problems?

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.

Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                          dream.  code.

More information about the thelist mailing list