Bug #12954 in connection string, charset selecting
Submitted: 2 Sep 2005 18:32 Modified: 21 Sep 2005 23:09
Reporter: Mustafa AYGUN Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51 OS:Windows (win 2000)
Assigned to: Jorge del Conde CPU Architecture:Any

[2 Sep 2005 18:32] Mustafa AYGUN
Description:
i use visual basic with mysql. But i can't use visual data objects with mysql. Because Exmp. Adodc, i build connection string then i can't see my table names in original. My Table Names and datas are in Turkish.
is there any choice to select charset in connection string?
in java odbc it is avaible, buy in odbc it's not.

i only use my datas with code object. Becuse i execute "Set Names 'latin5';" at first

How to repeat:
in visual basiv, insert an adodc contol, then connect to database and select source table

Suggested fix:
in odbc connection string we can say and add  "Charset=latin5"
[2 Sep 2005 20:35] Jorge del Conde
Hi!

Can you please send us a test-case that reproduces this behavour ?

Thanks a lot
[5 Sep 2005 13:18] Mustafa AYGUN
This access database includes Turkish language characters, try to migrate to mysql

Attachment: cep.mdb (application/msaccess, text), 164.00 KiB.

[5 Sep 2005 13:29] Mustafa AYGUN
in this visual basic project try to connect database. (included in rar file)

Attachment: Test program.rar (application/octet-stream, text), 2.92 KiB.

[15 Sep 2005 20:02] Mustafa AYGUN
there is no problem now. i insert `STMT=use names 'latin5'` into connection string and there is no problem. thanks for your notes..
[21 Sep 2005 23:09] Jorge del Conde
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php