Bug #2685 Turkish Character problem with Mysql JDBC driver
Submitted: 9 Feb 2004 7:52 Modified: 9 Feb 2004 8:05
Reporter: Ferdi SALDIRIS Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:mysql-connector-java-3.0.10-stable OS:Microsoft Windows (Windows XP)
Assigned to: CPU Architecture:Any

[9 Feb 2004 7:52] Ferdi SALDIRIS
Description:
Hi, 

  I have a problem with show to turkish character of the JDBC driver 
for MYSQL. I have a mysql database.And It's default-character-set is 
latin5.(This is supporting the turkish characters) 

  I can see Turkish character with database engine programs so as 
MySQL Control Center. But I can not display with show to turkish 
character(ç,ö,) of the JDBC driver for MYSQL. 

My system information:
 Application server : Extended OC4J 
 Development Tool   : Oracle JDevepor 9.0.3

What can I do? 

Thanks.. 

How to repeat:

  I can see Turkish character with database engine programs so as 
MySQL Control Center. But I can not display with show to turkish 
character(ç,ö) of the JDBC driver for MYSQL. 

My system information:
 Application server : Extended OC4J 
 Development Tool   : Oracle JDevepor 9.0.3
[9 Feb 2004 8:05] Mark Matthews
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.
[9 Feb 2004 8:05] Mark Matthews
Please submit a testcase that includes code/SQL which reproduces this issue.
[9 Feb 2004 10:38] Ferdi SALDIRIS
demo for this issue

Attachment: demo.zip (application/x-zip-compressed, text), 2.31 KiB.

[9 Feb 2004 10:40] Ferdi SALDIRIS
I am using mysql-connector-java-3.0.10-stable-bin Connecter/J from this demo

Thank you for everything..
[9 Feb 2004 10:41] Ferdi SALDIRIS
I was send a demo file for this issue.It'is in files link.
[4 Jan 2006 14:31] Ahmed Yasin Koculu
I have found the solution at last.
Here is the solution:
Connection dbConn; //after creating connection
...
...
dbConn.setEncoding("latin5"); //set your connection encoding
...
//after connection has been established send this query to the server
sqlQuery("set character set latin5");

i try this with latin5_turkish_ci
may be this works for utf8_turkish_ci

http://www.aykoc.com
[8 Jun 2006 20:38] Cengiz Türkoglu
Hi,

please have a look at the following link to solve (it's one of several ways) the problem with UTF-8:

http://forums.mysql.com/read.php?39,18654,95115#msg-95115

Regards
Cengiz