Yes you are right it works... but if the documentation is wrong I will be
wrong in the following also...
Majority of SET statements are documented without quotes:
AUTOCOMMIT = {0 | 1}
BIG_TABLES = {0 | 1}
FOREIGN_KEY_CHECKS = {0 | 1}
IDENTITY = value
INSERT_ID = value
LAST_INSERT_ID = value
SQL_AU
On 2006-03-20, at 16:12, Gabriel PREDA wrote:
One must issue immediately after connection:
SET NAMES 'utf8'
Also look at:
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';
Server must know what you are assking for... and they ALL have to
"talk the
same language" !!
One must issue immediately after connection:
SET NAMES 'utf8'
Also look at:
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';
Server must know what you are assking for... and they ALL have to "talk the
same language" !!!
--
Gabriel PREDA
Senior Web Developer
I have problem with UTF-8 character set.
I use MySQL 5 and Tomcat 5.5.9.I use NetBeans for
programinnig
in Java.
I made one database and is in UTF8,also all my JSP
pages are set to
UTF8 encoding,and also all HTML are set to UTF8.
When i put ,đ,č,ć, character date in
database directly from MySQL
