Bug #8210 private void LoadCharacterSets()
Submitted: 31 Jan 2005 11:59 Modified: 31 Jan 2005 20:01
Reporter: Ahmet CAN Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version: OS:
Assigned to: Reggie Burnett CPU Architecture:Any

[31 Jan 2005 11:59] Ahmet CAN
Description:
i m  using mysql 4.1.9 version and MySQL Connector/Net 1.0.4 

when i try to connect database server

-->mysqlconnection.open()

occuring a general exception 

ex:-->Could not find specified column in results

i resolve this problem as this 

in
driver.cs\
private void LoadCharacterSets() 

-error line charSets[ Convert.ToInt32(reader["id"]) ] = reader["charset"];

+charSets[ Convert.ToInt32(reader["Id"]) ] = reader["charset"]; 

lower "i"  is muste be "I" 
but i dont know why

How to repeat:
---

Suggested fix:
i m  using mysql 4.1.9 version and MySQL Connector/Net 1.0.4 

when i try to connect database server
-->mysqlconnection.open()
occuring a general exception 
ex:-->Could not find specified column in results

i resolve this problem as this 

in
driver.cs\
private void LoadCharacterSets() 

-error line charSets[ Convert.ToInt32(reader["id"]) ] = reader["charset"]; Id

+charSets[ Convert.ToInt32(reader["Id"]) ] = reader["charset"]; 

lower "i"  is muste be "I" 
but i dont know why
[31 Jan 2005 20:01] Reggie Burnett
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.

Additional info:

I can't repeat this.  can you give me more information?  This really should not occur since the [] indexer uses the function GetOrdinal that uses .ToLower() on both the name given and the name in the field metadata for comparison.  It should be doing a case -insensitive compare.
[9 Jul 2005 22:08] Yasin Hinislioglu
I have same problem. Let me give some information about this bug.

Operating System : Windows XP Pro SP2
Language            : Turkish

This bug is related with Turkish character set. In Turkish character set lowercase 'i' and uppercase 'i' characters are different. So the following statement generates a bug.
      charSets[ Convert.ToInt32(reader["id"]) ] = reader["charset"];

When we execute command "SHOW Collation" we see that 3rd column is named as "Id" so first character is uppercase. In the Turkish char set Uppercase("id") is equal to "İD".So "İD" is not equal to "Id" that is why database throws "Could not find specified column in results" exception. The statement should be
      charSets[ Convert.ToInt32(reader["Id"]) ] = reader["charset"];

to solve the problem.

If case sensitivity is used then that type of bug would have not been occured..