Christian Traber wrote: > Now I know a I cannot use every lc_ctype with every encoding, > but where can I find a list of valid encoding/locale combinations? Try something like the following: for x in $(locale -a); do echo -n "$x: "; LC_ALL=$x locale charmap; done Unfortunately, the name of the encoding that the locale system uses might differ from the locale name that PostgreSQL uses, so you will have to be able to see through that. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend