MySQL Forums
Forum List  »  Quality Assurance

Bug or brainfart
Posted by: Søren Møller Hansen
Date: November 02, 2007 02:01AM

I'm experiencing some difficulties with the MySQL charsets.

Take a look at the following data:

TABLE billing:
|-------|
| title |
|-------|
| lytte |
| lütte |
---------

Then take a look at the following query:

SELECT title FROM billing WHERE title = 'lytte'

This query would return both records in table, why?

I've tried using STR_COM(), but it returns the same results.

But there is a workaround for this issue:

SELECT title FROM billing WHERE HEX( title ) = HEX( 'lytte' )

However I would classify this solution as a hack. Is this issue a bug or am I just missing something?

I'm running MySQL 5.1 and the cell collation is utf8_danish. The table and database collation is latin1_danish_ci. However I remember having tried other collations without any difference.

Options: ReplyQuote


Subject
Views
Written By
Posted
Bug or brainfart
3287
November 02, 2007 02:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.