Oleg Bartunov writes: > I thought I could specify different encodings for different databases > and these encodings will be used in text operations (sort, upper,lower), > not just for conversion. But, actually, the only encoding is important > for text operations - the one specified with 'initdb' command ! Is't > true ?
Absolutely not, but you may find that in order to allow LC_CTYPE operations (namely sort, upper, lower) in UTF8, you need a locale that supports that, namely the xx_XX.utf8 kind. So realistically, you are kind of stuck with one encoding for the entire cluster. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings