Re: order by a string

so the only way i come around this problem is dump my db. drop the db. and do a initdb with the right settings and run my dump on the new one?
how can i figure out which locale is set on the suse machine (i am a linux novice, sorry)?
which locale i should set on the suse machine for use in a german language environment, and how do i do it?
thanx for your help!
stefan

Peter Eisentraut wrote:

Stefan Leitich writes:
 

i am developing with version 7.3.2 under cygwin. my production
evironment is 7.3.3 on a suse machine.
language settings (lc_...) for the server are on developing and
production machine the same, 'C'.
now i encoutered the following behaviour. i use a union select to unify
a query result with an ' (all)' entry.
i used at home a space on first character to ensure this entry will be
on top if i am ordering by the column.
it works in developing environment but it doesnt in production. in
production i got a ordering result wich ignores special chars like my
whitespace and the '('  and the all entry so comes for example after
'akk' and before 'amm'.   

That is a pretty clear indication that the locale on the production
machine is not, in fact, C.  Note that the locale is set when the cluster
is initialized, so you may need to re-initdb.