Search Postgresql Archives

Re: "Invalid multibyte character for locale" still there

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux