Re: help with mysql
"Corey Ehmke" <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
Gino, You want to make sure that the target database is set up for UTF-8 characters. You might also double-check that your data dump's CREATE TABLE statements have the character set attribute set (e.g. CREATE TABLE `sample` ( `pk_id` int(11) NOT NULL, `firstname` varchar(100) NOT NULL, `lastname` varchar(100) NOT NULL, PRIMARY KEY (`pk_id`), UNIQUE KEY `pk_id` (`pk_id`) ) TYPE=InnoDB CHARACTER SET utf8 ; How are you creating your dump file? Make sure that you're using the -r flag with mysqldump (e.g. mysqldump -r sample.sql) instead of directing output to a file using >; otherwise, your terminal may mess up the UTF encoding. Finally, if problems persist, you might check http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html for other tips. Best, Corey --- Corey Ehmke Director of Professional Services Capps Digital 35 W. Wacker Drive Chicago, IL 60601 312.220.3096 [email protected] >>> Gino Pacitti <[email protected]> 08/19/06 7:05 AM >>> Hi all I have a database with 5 different languages used for products in different tables. I did a mysql dump and loaded that into a new database on new machine - all the foreign charaters are weird now... how can I get a correct set of characters? Gino _______________________________________________ WebObjects-dev mailing list [email protected] http://www.omnigroup.com/mailman/listinfo/webobjects-dev