Bug #11621 connector does not support charset cp1250
Submitted: 28 Jun 2005 22:43 Modified: 12 Jul 2005 5:32
Reporter: Miloslav Siroky
Status: Closed
Category:Connector/Net Severity:S3 (Non-critical)
Version:1.0.4 OS:Microsoft Windows (win 2000)
Assigned to: Reggie Burnett Target Version:

[28 Jun 2005 22:43] Miloslav Siroky 
Description:
Server 4.1.12, using cp1250 through ODBC works, when trying to use .net connector 'cp1250
is not supported' appears in both cases I use charset in connection string or not.

How to repeat:
Settin default character set for server in my.ini to cp1250 or using charset=cp1250 in
connection string in .net connector
[30 Jun 2005 11:15] Vasily Kishkin 
Could you please write here table definition and sample test case ?
[30 Jun 2005 16:20] Miloslav Siroky 
Example of table

CREATE TABLE `dotdata55`.`kl_sample2` (
  `Klient_c` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Prijmeni` VARCHAR(50) NOT NULL,
  `Jmeno` VARCHAR(50) NOT NULL,
  `Titul` VARCHAR(50),
  `Pohlavi` TINYINT UNSIGNED NOT NULL,
  `Datum_nar` DATE,
  `Narodnost` VARCHAR(45),
  `Statni_pris` VARCHAR(25),
  `Ulice_a_cp` VARCHAR(150) NOT NULL,
  `Obec` VARCHAR(50) NOT NULL,
  `PSC` VARCHAR(8) NOT NULL,
  PRIMARY KEY(`Klient_c`)
)
ENGINE = MYISAM;

Here is a sample of data, but I'm afraid it is damaged through export. Originaly the data
is in cp1250 and if I view them through MyODBC (from MS Access) it's right if server is
configured to default character set cp1250. But with this settings I can't connect to the
server through .net connector, so I must use latin2 as def. charset. If i change the
setting directly in table (i.e. server=latin2, table=cp1250), the connection is opened by
.net connector and the same error occurs when try to read data from this table, e.g. by
mysqldataadapter.fill method. I think this does not depend on data values in table. If it
helps, I can send the buffer tracing displaying with error message.
So the data (copied from csv, dont know if it is useful...)
"Klient_c","Prijmeni","Jmeno","Titul","Pohlavi","Datum_nar","Narodnost","Statni_pris","Uli
ce_a_cp","Obec","PSC"
1110002,"Koucký","Václav","",1,"","česká","ČR","Obětí Nacismu
1","Semily","50505"
1110003,"Kry?pin","Jiří","",1,"","česká","ČR","Ládevská
9","Semily","50505"
1110004,"Halířová","Milena","",2,"","česká","ČR","Horova
23/2","Semily","50505"
1110006,"Urban","Vladimír","",1,"","česká","ČR","Pod Hybšmankou
7","Semily","50505"
1110007,"Mutňanská","Václava","",2,"","česká","ČR","Ve
Střešovičkách 47","Semily","50505"
1110008,"Zajícová","Drahu?e","",2,"","česká","ČR","Ovocnářská
596","Semily","50505"
1110009,"Milo?","Kuchtář","",1,"","česká","ČR","Dvořákova
3","Semily","50505"
1110010,"Krejčí","Lubo?","",1,"","česká","ČR","Chaloupeckého
5","Semily","50505"
1110013,"Matou?ek","Vladimír","MUDr.",1,"","česká","ČR","Horákova
740","Semily","50505"
1110017,"Eisenbruk","Jiří","PhDr.",1,"","česká","ČR","Melkusova
28","Semily","50505"
1110019,"Stejskal","Michal","",1,"","česká","ČR","Vysočanská
237","Semily","50505"
1110020,"?tukavec","Alois","",1,"","česká","ČR","Úprkova 1","Semily","50505"
1110025,"?onovský","Tomá?","Ing.",1,"","česká","ČR","Generála Píky
6","Semily","50505"
1110028,"Motička","Tomá?","",1,"","česká","ČR","","Semily","50505"
[30 Jun 2005 20:53] Reggie Burnett 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fixed in 1.0.5
[11 Jul 2005 13:50] Miloslav Siroky 
Thank you for solving! Now I can't find more info about how to access the source
repository of this connector and build the version. Or, is it possible to say
approximately when the next release is available?
[12 Jul 2005 5:32] Paul DuBois 
Noted in Connector/NET 1.0.5 changelog.
[18 Jul 2005 14:20] Miloslav Siroky 
But no documentation for Connector/Net is available on the web, so I cannot get the 1.0.5
changelog. There is only Connector/J and ODBC documentation