Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Mon May 12 2008 - 09:21:22 CDT
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
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
>From: Waynn Lue [mailto:waynnluegmail.com]
>Sent: Saturday, May 10, 2008 7:37 AM
>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.
>This essentially is dump and recreate the db.
>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.
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartzthe-
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql