Thanks Clemens,
Schwaighofer Clemens schreef:
On Wed, Mar 11, 2009 at 19:01, Marc Cuypers <m.cuypers@xxxxxxx> wrote:
Thanks Tom,
Only...
One database was in LATIN9. When creating this database i got the same
error.
Command:
CREATE DATABASE "hardsoft" WITH OWNER = postgres TEMPLATE = template0
ENCODING = 'LATIN9';
Error:
ERROR: encoding LATIN9 does not match server's locale nl_BE.utf8
SQL state: XX000
Detail: The server's LC_CTYPE setting requires encoding UTF8.
Can i only use nl_BE and UTF-8 now?
Why can't i use LATIN9 anymore?
Is bacula 8.3 stricter in this respect to 7.4?
yes, you can no longer mix encodings in utf8. That has something to do
with the sort (or so).
Anyway, for the one DB that you have in Latin1, dump this extra,
convert the whole file to utf8 with iconv, replace the Latin1 strings
in it to UTF8 and your good to go.
That's what i'll do. Thanks again.
--
Marc
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
