| 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 16:54]
Vasily Kishkin
Could you please check character set according to follow URL: http://dev.mysql.com/doc/refman/5.0/en/charset-defaults.html
[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
Description: 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