Re: MySQL 4.1.3 Java/UTF8 support question

2004-11-26 Thread Ramesh Vadlapatla
Hi Gleb, The problem was with the JDBC Connect string, earlier it was; jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=utf8 I changed that to: jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=UTF-8 and it works now. thanks, Ramesh On Fri, 26 Nov 2004 13:53:

Re: MySQL 4.1.3 Java/UTF8 support question

2004-11-26 Thread Gleb Paharenko
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: > [my

MySQL 4.1.3 Java/UTF8 support question

2004-11-25 Thread Ramesh Vadlapatla
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