Thank you all very much for your help.
Maximilian, we simplified your replacing code:
replace(replace(replace(replace(replace(replace
($1,'Ä','A'),'Ö','O'),'Ü','U'
),'ä','a'),'ö','o'),'ü','u');
to this:
translate(upper($1),'ÄÖÜ','AOU')
Paul
Am 29.09.2009 um 14:36 schrieb
On Tue, 2009-09-29 at 03:21 -0600, Scott Marlowe wrote:
On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar devl...@revolversoft.com wrote:
Hi!
We have big problems with collation in ORDER BY, which happens in binary
order, not alphabetic (lexicographical), like:.
A
B
Z
a
z
Ä
Ö
Hi!
We have big problems with collation in ORDER BY, which happens in
binary order, not alphabetic (lexicographical), like:.
A
B
Z
a
z
Ä
Ö
ä
ö
This is what we have done:
1. initdb -U myuser -E UTF-8 --locale=de_DE.UTF-8 -D /mydata
2. pg_ctl -U myuser -D /mydata -l logfile start
3.
On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar devl...@revolversoft.com wrote:
Hi!
We have big problems with collation in ORDER BY, which happens in binary
order, not alphabetic (lexicographical), like:.
A
B
Z
a
z
Ä
Ö
ä
ö
PG is running on Mac OS X 10.5 and 10.6 Intel.
I seem to
am 29.09.2009 11:21 Uhr schrieb Scott Marlowe unter scott.marl...@gmail.com:
On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar devl...@revolversoft.com wrote:
Hi!
We have big problems with collation in ORDER BY, which happens in binary
order, not alphabetic (lexicographical), like:.
A
B
Z