Thread: Problems with select lower()
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 --
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
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.