pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedselect lower('ÆØÅ ABC'); does not work as expected
2+ messages / 2 participants
[nested] [flat]
* select lower('ÆØÅ ABC'); does not work as expected
@ 2003-05-23 14:33 willy malth <donotemailme@nosuchdomain.xx>
2003-05-25 03:07 ` Re: select lower('ÆØÅ ABC'); does not work as expected Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: willy malth @ 2003-05-23 14:33 UTC (permalink / raw)
To: pgsql-sql
Hi there!
I'm useing postgresql 7.3.2, and having trouble with the lower(string)
function and the Danish special chars:
mydatabase=> select lower('ÆØÅ ABC');
lower
---------
ÆØÅ abc
(1 row)
The Danish chars does not convert to lower chars.
I've seen answers to this problem, suggesting a configure option called
--enable-locale, but this does not apply to 7.3.2 as it says in the
release notes: "Both multibyte and locale support are now always
enabled.". The --enable-locale option is no longer there.
Any ideas?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: select lower('ÆØÅ ABC'); does not work as expected
2003-05-23 14:33 select lower('ÆØÅ ABC'); does not work as expected willy malth <donotemailme@nosuchdomain.xx>
@ 2003-05-25 03:07 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-05-25 03:07 UTC (permalink / raw)
To: willy malth <donotemailme@nosuchdomain.xx>; +Cc: pgsql-sql
willy malth <donotemailme@nosuchdomain.xx> writes:
> I'm useing postgresql 7.3.2, and having trouble with the lower(string)
> function and the Danish special chars:
> The Danish chars does not convert to lower chars.
You need to run initdb in the correct locale. LC_COLLATE and LC_CTYPE
are both locked down at initdb time, and the latter determines the
behavior of lower(). You could use pg_controldata to check the
database's LC_CTYPE, but I'll bet that it's not a Danish locale.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-05-25 03:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-23 14:33 select lower('ÆØÅ ABC'); does not work as expected willy malth <donotemailme@nosuchdomain.xx>
2003-05-25 03:07 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox