MySQL Bugs: #11876: ToLower method causes error for language iso 8859-9

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:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	1.0.4	OS:	Any (All)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
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.

Could you please provide a table definition and some test case ?

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".

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,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `bug_table` */

insert into `bug_table` values (1,'izmir'),(2,'İZMİR'),(3,'IZMIR');
==================================================

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.

This was already reported as bug # 8228 and has been fixed.