Bug #2685 Turkish Character problem with Mysql JDBC driver

• Submitted: 9 Feb 2004 7:52
• Modified: 9 Feb 2004 8:05
• Reporter: Ferdi SALDIRIS
• Status: Can't repeat
• Category: Connector / J
• Severity: S1 (Critical)
• Version: mysql-connector-java-3.0.10-stable
• OS: Windows (Windows XP)
• 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