Re: Why mysql_query("SET NAMES 'utf8'");
Posted by: Rick James
Date: February 23, 2009 10:37AM

Several questions intertwined on this thread.

SET NAMES seems to be needed in a lot of cases.

utf8_unicode_ci is better than utf8_general_ci for handling collation (ordering) of double characters (eg German ß, Spanish ch, ll), etc.

Inserting non-utf8 into a utf8 columns usually truncates the string (silently). So, the ??? probably implies failure to SET NAMES on the way out.

There is a web page on SET NAMES on mysql.com

Web pages should start with
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
(Not just the form page, but also resulting display pages)

Options: ReplyQuote


Subject
Views
Written By
Posted
77885
April 14, 2005 08:17PM
Re: Why mysql_query("SET NAMES 'utf8'");
12468
February 23, 2009 10:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.