Try setting the column to binary, that what worked for me. Shannon
--- awk <[EMAIL PROTECTED]> wrote: > >Description: > Somehow the letter 'O' is not equivalent to the > letter '�' (O with > umlaut), in string matching. > > >How-To-Repeat: > I tried the following query in MySQL: > > SELECT 'e'='�', 'o'='�'; > > (ie, select 'e' = e-with-umlaut, 'o' = > o-with-umlaut) > > And the result: > > +---------+---------+ > | 'e'='�' | 'o'='�' | > +---------+---------+ > | 1 | 0 | > +---------+---------+ > > I believe both results should be '1' with Latin-1? > > I tried it on Linux (MySQL 3.23.46) and FreeBSD > (3.23.42) with > the same results. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
