Marian POPESCU <softexpert@xxxxxxxxxxxxxx> writes: > I put up a testcase at > http://perso.netpratique.fr/softexpert/pgsql/unicodetest.data.gz After experimenting, the only case in which I could get that failure was to deliberately force a database encoding incompatible with the locale, namely initdb with LC_ALL=en_US (which is implicitly Latin1 on FC3) and then "createdb -E unicode". So I think this is pilot error. You need to be careful to use a database encoding consistent with the locale setting. (In 8.0, initdb should usually get this right if you don't override it.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings