Re: SOLVED upgrade from 7.4 to 8.3

Thanks Clemens,


Schwaighofer Clemens schreef:
> On Wed, Mar 11, 2009 at 19:01, Marc Cuypers <m.cuypers@mgvd.be> 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