From: | Schwaighofer Clemens <clemens(dot)schwaighofer(at)tequila(dot)jp> |
---|---|
To: | Marc Cuypers <m(dot)cuypers(at)mgvd(dot)be> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: upgrade from 7.4 to 8.3 |
Date: | 2009-03-11 10:33:55 |
Message-ID: | fed954960903110333l5bc2cd37l7cddc33c21c26df6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 11, 2009 at 19:01, Marc Cuypers <m(dot)cuypers(at)mgvd(dot)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.
--
[ Clemens Schwaighofer -----=====:::::~ ]
[ IT Engineer/Manager ]
[ E-Graphics Communications, TEQUILA\ Japan IT Group ]
[ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7703 Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.jp ]
Advertising Age Global Agency of the Year 2008
Adweek Global Agency of the Year 2008
This e-mail is intended only for the named person or entity to which
it is addressed and contains valuable business information that is
privileged, confidential and/or otherwise protected from disclosure.
Dissemination, distribution or copying of this e-mail or the
information herein by anyone other than the intended recipient, or
an employee or agent responsible for delivering the message to the
intended recipient, is strictly prohibited. All contents are the
copyright property of TBWA Worldwide, its agencies or a client of
such agencies. If you are not the intended recipient, you are
nevertheless bound to respect the worldwide legal rights of TBWA
Worldwide, its agencies and its clients. We require that unintended
recipients delete the e-mail and destroy all electronic copies in
their system, retaining no copies in any media.If you have received
this e-mail in error, please immediately notify us via e-mail to
disclaimer(at)tbwaworld(dot)com(dot) We appreciate your cooperation.
We make no warranties as to the accuracy or completeness of this
e-mail and accept no liability for its content or use. Any opinions
expressed in this e-mail are those of the author and do not
necessarily reflect the opinions of TBWA Worldwide or any of its
agencies or affiliates.
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2009-03-11 10:57:08 | Re: upgrade from 7.4 to 8.3 |
Previous Message | Marc Cuypers | 2009-03-11 10:01:02 | Re: upgrade from 7.4 to 8.3 |