Hi Gleb, The problem was with the JDBC Connect string, earlier it was; jdbc:mysql://localhost:10000/db1?useUnicode=true&characterEncoding=utf8
I changed that to: jdbc:mysql://localhost:10000/db1?useUnicode=true&characterEncoding=UTF-8 and it works now. thanks, Ramesh On Fri, 26 Nov 2004 13:53:43 +0200, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]