UTF-8
6 views
Skip to first unread message
Marc Hughes
Jan 10, 2011, 9:00:15 PM1/10/11
to scrum...@googlegroups.com
Looks like I made a mistake when creating our DB. The tables are set up for latin1 character set instead of utf-8.
I believe executing queries like this will fix it:
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Locally, on my machine it works, I'll spend some more time testing it.
-Marc
I believe executing queries like this will fix it:
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Locally, on my machine it works, I'll spend some more time testing it.
-Marc
Reply all
Reply to author
Forward
0 new messages