Bug #3935 Greek

• Submitted: 30 May 2004 11:19
• Modified: 3 Jun 2004 14:03
• Reporter: Ivo Radev
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.15
• OS: Linux (Mandrake Linux)
• CPU Architecture: Any

[30 May 2004 11:19] Ivo Radev

Description:
Hello,

We have a "small" problem. We made a movie database and everything is working fine till now. The point is, that some days ago the database is giving us an error by inserting a name in it. It's saying that it is duplicated. I have searched the whole table name by name, nothing, the mysql search finds it not too. The point is, that some actors are written in greek. So, the problem is coming with the greek characters. lets say, if you write Kakogiannis in greek, and after that you try to add Kalogiannis, it's says that you have a duplicated name, in fact you don't. it's counting the K and the L (in greek!) as the same character. Friends of me have tried it on different versions ... the same result.

How to repeat:
Insert first something in a table in greek, lets say the name Kalogiannis. Then try to insert Kakogiannis. you should have an unique key, so you do not have duplicates. And still, you will get an error, that the name already exists, what, like we can see, it's not true.

Suggested fix:
I suggest, the team to have a look on the character set, some how the SQL is taking the K and the L in the greek as the same character.

[1 Jun 2004 13:45] MySQL Verification Team

Thank you for writting to us.

As I am living on the greek island, I know what you are talking about.

Full solution is in 4.1.2.

In 4.0 you have to excape every string, just as explained in our manual.

[3 Jun 2004 14:03] MySQL Verification Team

See if setting a default charset to greek helps.