Joost Kraaijeveld wrote: > But I cannot find where I have to configure what locale in the OS to > get UTF8 as default encoding for the databases. (I read > http://www.postgresql.org/docs/8.1/static/multibyte.html but that did > not give me that info). Can you tell me this or give me a pointer to > the answer?
You should try something like nl_NL.utf8. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match