Bug#290118: postgresql could not be configured to handle characters others than ASCII correctly

[barbier@linuxfr.org (Denis Barbier)]

reassign 290118 postgresql
thanks

[Martin Pitt]
> PostgreSQL uses the normal libc toupper()/tolower()/etc. functions (as
> can be seen in src/backend/utils/adt/oracle_compat.c). Unfortunately
> the libc functions do not support non-ASCII characters for now, so
> this does not work throughout the system (besides, it is a hell of a
> job to actually implement this since you need a mapping of probably
> thousands of characters).

These functions are defined for single-byte locales, there are
alternatives for multi-byte locales.  But please read this thread
  http://mail.nl.linux.org/linux-utf8/2004-12/msg00007.html
before patching oracle_compat.c, case conversion must not be performed
in place.

Denis