Bug #14058 Data INSERT failure
Submitted: 16 Oct 2005 14:31 Modified: 17 Oct 2005 9:50
Reporter: Stanislav Vorobiov Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.23 OS:Windows (Windows XP SP2)
Assigned to: CPU Architecture:Any

[16 Oct 2005 14:31] Stanislav Vorobiov
Hi, I have a problem inserting different data in unique column, because MySQL thinks it's identical, example:
INSERT INTO my_table (name) VALUES ('Андрей')
Неre 'Андрей' is spelled using only russian letters
after that I call
INSERT INTO my_table (name) VALUES ('Aндрей')
Here 'Aндрей' is spelled using first letter 'A' as english, and the rest are russian letters. MySQL thinks that they're two identical strings, but they're not, what's wrong here ?

How to repeat:
Just execute thiese two statements
[16 Oct 2005 16:54] Vasily Kishkin
Could you please check character set according to follow URL:

[16 Oct 2005 22:06] Stanislav Vorobiov
Hm, this documentation refers to MySQL 5.0 not to 4.0.X
My MySQL don't understand SHOW COLLATION statement.
[17 Oct 2005 8:32] Hartmut Holzgraefe
ok, in 4.0 there is no distinction between character sets and collations yet,
so a simple "SHOW VARIABLES LIKE 'char%'" should do.
[17 Oct 2005 9:50] Stanislav Vorobiov
Thanks, everything is fixed by changing default charset