MySQL Forums :: Connector/JDBC and Java :: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1


Advanced Search

Re: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1
Posted by: Jason Xu ()
Date: September 28, 2009 09:47PM

I've the same problem (debian 5)
My solution is:

Go to the [mysqld] section in my.cnf and add two strings:

collation_server=utf8_general_ci
character_set_server=utf8

Options: ReplyQuote


Subject Written By Posted
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1 Alin Haid 08/30/2009 08:36AM
Re: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1 Alin Haid 08/31/2009 05:03AM
Re: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1 Peter Brawley 08/31/2009 10:54AM
Re: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1 Jason Xu 09/28/2009 09:47PM
Re: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1 Pascal LAVAUX 11/13/2009 09:32AM
Re: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1 Jason Shu 11/13/2009 07:25PM


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.