pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problems 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