Sorting in Icelandic.

Hi there.

As far as I can see, mySQL does not sort Icelandic words correctly. Is
there anything I (or you) can do to fix it?

Correct sorting order: =
a=E1bcd=F0e=E9fghi=EDjklmno=F3pqrstu=FAvwxy=FDz=FE=E6ö
A=C1BCD=D0E=C9FGHI=CDJKLMNO=D3PQRSTU=DAVWXY=DDZ=DE=C6=D6

None of these characters are equivalent, so you cannot sort '=E1' as if =
it
were 'a' or '=E9' as if it were 'e' (but upper and lower case are
equivalent, so 'a' amounts to the same as 'A', '=E1' as the same as =
'=C1'
etc.).

Thanks,
Arni Sigurjonsson
www.landskerfi.is
Iceland


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org
arni [ Mo, 28 April 2003 14:41 ] [ ID #67706 ]

Re: Sorting in Icelandic.

=C1rni Sigurj=F3nsson writes:
> Hi there.
>
> As far as I can see, mySQL does not sort Icelandic words correctly. I=
s
> there anything I (or you) can do to fix it?
>
> Correct sorting order: a=E1bcd=F0e=E9fghi=EDjklmno=F3pqrstu=FAvwxy=FD=
z=FE=E6ö
> A=C1BCD=D0E=C9FGHI=CDJKLMNO=D3PQRSTU=DAVWXY=DDZ=DE=C6=D6
>
> None of these characters are equivalent, so you cannot sort '=E1' as =
if it
> were 'a' or '=E9' as if it were 'e' (but upper and lower case are
> equivalent, so 'a' amounts to the same as 'A', '=E1' as the same as '=
=C1'
> etc.).
>
> Thanks,
> Arni Sigurjonsson
> www.landskerfi.is
> Iceland
>

Yes, you can do.

Can you send us a character set for Icelandic ???

Isn't it same as Danish ???

Please take a look at share/charsets directory and make icelandic
charset and send it to us.


Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=3Dm=
smi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa [at] mysql.com=
>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org
Sinisa Milivojevic [ Di, 29 April 2003 14:21 ] [ ID #67714 ]
Datenbanken » gmane.comp.db.mysql.bugs » Sorting in Icelandic.

Vorheriges Thema: Possible MySQL 4.0.12 bug regarding UNION operand ordering
Nächstes Thema: INSERTING AND DELETING ROWS IN THE SAME SESSION.