postgres 7.4 on linux, glibc 2.2.4-6
I've a table containing unicode-data and the lower()-function does not work proper. While it lowers standard letters like A->a,B->b ... it fails on special letters like german umlauts (Ä , Ö ...) that are simply keeped untouched.
Everything else (sorting etc.) is working fine and LC_COLLATE, LC_CTYPE and all the other locales were set proper to 'de_AT.UTF-8' (thats how my mandrake-systems calls the needed locale. On most other systems its called 'de_AT.utf8') when doing initdb.
The database-encoding is unicode, but I also tried SQL_ASCII (just to give it a try) and the same problem.
Whats the problem here?
The following output is copied from a unicode-terminal and copied to the newsreader. It looks fine here, so I think you can all read it.
# select oid,t,lower(t),length(t) from test order by t; oid | t | lower | length -------+-------+-------+-------- 17257 | a | a | 1 17268 | A | a | 1 17291 | ä | ä | 1 17265 | Ä | Ä | 1 17269 | B | b | 1 17275 | ñ | ñ | 1 17277 | Ñ | Ñ | 1 17262 | ö | ö | 1 17266 | Ö | Ö | 1 17267 | Ü | Ü | 1
# /usr/local/pgsql/bin/pg_controldata /data/postgresql_de/ | grep LC LC_COLLATE: de_AT.UTF-8 LC_CTYPE: de_AT.UTF-8
I would be very happy to get a "solution", but a workaround would be better than nothing ;) perl on the same system can read the data from the database and lowercase the data without any problems, but this is too much of a *WORK* *AROUND* :)
thnx a lot, peter
ps: of course upper does not work as well !!
pps: I looked up the changes on newer postgresql-version, but my topic did not apperar in the list, so I didnt try new 7.4.5. I think its merely a problem with setting than with postgreSQL. (at least I hope so ...)
-- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
