How to convert your MySQL table to accept UTF8 charactersets

October 19th, 2009

Getting “????” in your database rather than your Arabic or Chinese character sets? Try this:

ALTER TABLE contents CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Entry Filed under: Professional, SQL

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


RSS Berkman Gender & Tech

RSS Tweets

Tags

Meta