Bug #11876 ToLower method causes error for language iso 8859-9
Submitted: 12 Jul 2005 8:10 Modified: 19 Aug 2005 14:16
Reporter: Gokcer Gokdal Email Updates:
Status: Duplicate Impact on me:
Category:Connector / NET Severity:S2 (Serious)
Version:1.0.4 OS:Any (All)
Assigned to: Assigned Account CPU Architecture:Any

[12 Jul 2005 8:10] Gokcer Gokdal
As mysql connector uses ToLowerCase for index strings, at systems where Turkish language is inserted, some characters are converted to lowercase as used in Turkish which causes some severe errors (like null pointer exceptions according to failure to finding fields like "ID" which is converted to lowercase as "ıd" but needed "id"). Problem exists in c# but not checked other .net variants.

How to repeat:
Use table editor sample given by connector distribution in a system  using regional settings as Turkish.

Suggested fix:
I have fixed the problem by changing all ToLower() method calls with ToLowerInvariant() (specific to .net 2.0). ToLower(CultureInfo.InvariantCulture) can be used for previous releases.
[12 Jul 2005 11:33] Vasily Kishkin
Could you please provide a table definition and some test case ?
[12 Aug 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[16 Aug 2005 8:56] Gokcer Gokdal
You can use sql dump between "=====" lines. Please try to connect to the db by using a system having regional settings set to turkish.
SQLyog v4.07
Host - 4.1.12a-nt : Database - bug
Server version : 4.1.12a-nt

create database if not exists `bug`;

USE `bug`;

/*Table structure for table `bug_table` */

drop table if exists `bug_table`;

CREATE TABLE `bug_table` (
  `ID` int(11) NOT NULL default '0',
  `Initial_Name` varchar(25) default NULL,

/*Data for the table `bug_table` */

insert into `bug_table` values (1,'izmir'),(2,'İZMİR'),(3,'IZMIR');
[16 Aug 2005 8:58] Gokcer Gokdal
A file which contains "I" character as field name. This causes error because lowercase of "I" in turkish is not "i", it is "ı".

Attachment: bug_sql.sql (text/plain), 581 bytes.

[19 Aug 2005 14:16] Reggie Burnett
This was already reported as bug # 8228 and has been fixed.