Are you using mysqli, PDO, or mysql? There are differences in the way the character set is determined, as I discovered after much the same experience as yours.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com >-----Original Message----- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Saturday, May 10, 2008 7:37 AM >To: mysql@lists.mysql.com >Subject: latin1 vs UTF-8 > >I'm trying to store the symbol (R) (that's the registered trademark >symbol) in my database, but I get a weird Ctrl-A (^A) character >whenever I try. At first, I thought it was because I was calling >htmlentities without passing in "UTF-8" as the last argument, but that >only solved one of my problems. Then I spent some time looking at >encodings, and I'm trying to figure out if the fact that the charset >is set to latin1 is the reason why. > >Assuming it is, is there anything I can do to avoid having to dump the >database and recreate it with the other encoding? I've spent some >time tonight looking on the web and at MySQL's documentation on >charsets and these are the options I've come up with. >alter table TABLE_NAME convert to character set utf8; >I'm assuming this is just a regular alter table, which means I'm going >to have to take down my server for the duration of the change, which >can take long periods of time. > >http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_lati >n1_t.html >This essentially is dump and recreate the db. > >iconv >This was mentioned somewhere, but no one had a concrete implementation. > >Also, are there any gotchas in doing this? I assume I should check if >my mysql has support for UTF-8, that I need to issue SET NAMES 'utf8'; >or put it into my.cnf, and that my php code needs to output the >headers with UTF-8 as well. > >Thanks, >Waynn > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
