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)
Subject
Views
Written By
Posted
77885
April 14, 2005 08:17PM
21301
May 07, 2005 08:09AM
17488
December 06, 2007 10:10AM
11940
February 18, 2009 03:24AM
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.