pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems with select lower()
3+ messages / 3 participants
[nested] [flat]
* Problems with select lower()
@ 2004-04-22 08:55 Andreas Schmitz <a.schmitz@cityweb.de>
0 siblings, 2 replies; 3+ messages in thread
From: Andreas Schmitz @ 2004-04-22 08:55 UTC (permalink / raw)
To: pgsql-admin
Hello *,
I have a problem with select lower() using capital letters with diaeresis. I
tried with encoding SQL_ASCII und UNICODE.
newsdb=# select lower('Ökosteuer');
lower
------------
Ökosteuer
(1 row)
newsdb=# select lower('Andreas');
lower
---------
andreas
(1 row)
Any Ideas ?
regards,
-Andreas
--
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problems with select lower()
@ 2004-04-22 12:52 Tom Lane <tgl@sss.pgh.pa.us>
parent: Andreas Schmitz <a.schmitz@cityweb.de>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-04-22 12:52 UTC (permalink / raw)
To: a.schmitz@cityweb.de; +Cc: pgsql-admin
Andreas Schmitz <a.schmitz@cityweb.de> writes:
> I have a problem with select lower() using capital letters with diaeresis. I
> tried with encoding SQL_ASCII und UNICODE.
upper/lower currently only work with single-byte characters, so you need
to use one of the LATINn database encodings rather than UNICODE if you
want this functionality.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problems with select lower()
@ 2004-04-22 13:32 Peter Eisentraut <peter_e@gmx.net>
parent: Andreas Schmitz <a.schmitz@cityweb.de>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2004-04-22 13:32 UTC (permalink / raw)
To: a.schmitz@cityweb.de; +Cc: pgsql-admin
Am Donnerstag, 22. April 2004 10:55 schrieb Andreas Schmitz:
> I have a problem with select lower() using capital letters with diaeresis.
> I tried with encoding SQL_ASCII und UNICODE.
You need to set your locale to something useful (de_DE), not the encoding.
And lower() doesn't work with Unicode, but that is an independent issue.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-04-22 13:32 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-22 08:55 Problems with select lower() Andreas Schmitz <a.schmitz@cityweb.de>
2004-04-22 12:52 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-04-22 13:32 ` Peter Eisentraut <peter_e@gmx.net>
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