From: | Web Manager <web(at)inter-resa(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | Patrick Coulombe <pcoulombe(at)mediacces(dot)com> |
Subject: | Re: order by accents? |
Date: | 2000-07-07 18:23:22 |
Message-ID: | 3966201A.DC33D183@inter-resa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-07-07 18:24:19 | Re: Search for underscore w/ LIKE |
Previous Message | Tom Lane | 2000-07-07 18:21:38 | Re: Search for underscore w/ LIKE |