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

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: se

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

2007-08-09 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 'Å'