Re: order by accents?

Patrick Coulombe wrote:
>
> hi,
> if I do a query like this one :
>
> SELECT name from medias ORDER BY name
>
> name
> ----
> AAAA
> CCCC
> EEEE
> VVVV
> ZZZZ
> ÉCCC
> ----
> 6 rows
>
> Why the record : ÉCCC is at the end?
> HOW can I fix this?
>
> Thank you
> Patrick

Hello,

I have the same problem (the character is not recognized - we also use
french) and it seems that the only way around this "bug" is to install
Postgres with a local package... but many told me that is was slower and
not very useful... I did not try it.

Instead, we plan to create a second column with same french data but
without accents... The query will be based on that field for the order
by needs... not great, but I will do exactly what we expect and no
add-ons.

Hope this helps!

Bonne journée!
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Marc Andre Paquin