lower does not handle german umlaut 
Author Message
 lower does not handle german umlaut
If I perform a select lower() on uppercased german umlauts, these wont be
converted to lowercase. Is this a bug or a feature or did I just miss
some settings ?

thnx,
peter

--
mag. peter pilsl

phone: +43 676 3574035
fax  : +43 676 3546512


pgp-key available

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Sun, 25 Apr 2004 19:43:04 GMT
 lower does not handle german umlaut

Quote:

> If I perform a select lower() on uppercased german umlauts, these wont be
> converted to lowercase.

AFAIK this should work if (a) the system was built with --enable-locale
and (b) you are running it in an appropriate locale setting.  The
SQL lower() function just invokes the C library's tolower() conversion
routine, so if it doesn't work your beef is with tolower() ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Mon, 26 Apr 2004 01:31:49 GMT
 lower does not handle german umlaut

Quote:


> > If I perform a select lower() on uppercased german umlauts, these wont be
> > converted to lowercase.

> AFAIK this should work if (a) the system was built with --enable-locale
> and (b) you are running it in an appropriate locale setting.  The
> SQL lower() function just invokes the C library's tolower() conversion
> routine, so if it doesn't work your beef is with tolower() ...

try select to_ascii()

I use it for French

Cheers
Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 02 May 2004 17:24:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. german umlauts in SQL*plus/Windows w/ WE8PC850 charset

2. german umlaut signs false representation after read from SQL2000 database

3. oracle jdbc and german umlauts

4. ODBC, SQL and german umlauts

5. German Umlauts and ISQL

6. Troubles using German Umlauts with JDBC

7. German umlauts

8. DTS Import, German Umlaut, ignor some characters

9. INFORMIX and german "umlaut"

10. WebDB: German umlauts problem

11. oas+jservlets and german umlauts

12. Problems with the lower() and upper() functions and umlaut chars in 7.2


 
Powered by phpBB® Forum Software