Bug #3935 Greek
Submitted: 30 May 2004 11:19 Modified: 3 Jun 2004 14:03
Reporter: Ivo Radev Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.15 OS:Linux (Mandrake Linux)
Assigned to: CPU Architecture:Any

[30 May 2004 11:19] Ivo Radev

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.