Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters

2007-08-11 Thread VeeJay
*From: VeeJay* [EMAIL PROTECTED] To: mysql@lists.mysql.com, [EMAIL PROTECTED] Date: Fri, Aug 10, 2007 at 8:19 AM Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command

Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters

2007-08-10 Thread VeeJay
Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command like: select * from employees where fname LIKE 'Å%'; I get results starting with English alphabet 'A' but not with

Re: Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters

2007-08-10 Thread mysql
in addition to the correct character-set also set the appropriate collation sequence suomi VeeJay wrote: Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command like: