Hello. What output produced
show variables like '%char%'; show variables like '%colla%'; You should also set utf8 as server character set. See: http://dev.mysql.com/doc/mysql/en/Charset-defaults.html Ramesh Vadlapatla <[EMAIL PROTECTED]> wrote: > Hi, > > In my.cnf, I have: > [mysql] > default-character-set=utf8 > > When I connect via mysql client and try to run a query which has a > "CONCAT" string function, it works fine and I get the proper output. > Example: SELECT CONCAT ('a', ' - ', 'b') = a-b > > Now, I am trying to do make this work via Java and: > I use this JDBC Driver: mysql-connector-java-3.0.10-stable-bin.jar > Conn. String: > jdbc:mysql://localhost:10000/db1?useUnicode=true&characterEncoding=utf8 > > I get the same error as I would have without the above > "default-character-set=utf8", i.e: > ERROR 1270 (HY000): Illegal mix of collations > (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), > (utf8_general_ci,IMPLICIT) for operation 'concat' > > How do I fix this, so that even the Java Client understands to use the > utf8 character set and I don't have to put the _utf8 in my sql > statement? > > Appreciate your help. > > thanks, > Ramesh > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
