Encoding woes

Поиск
Список
Период
Сортировка
Искать
От
Bendik R.Johansen
Тема
Encoding woes
Дата
Msg-id
a496e56c5617140d93963277d29bcef7@gmail.com
Список
Дерево обсуждения
Encoding woes Bendik R.Johansen <bendik.johansen@gmail.com>
Re: Encoding woes Tom Lane <tgl@sss.pgh.pa.us>
Hello!
I am having a few encoding related problems.

1. I have a database set up on my Mac OSX machine, PostgreSQL 8.02. I 
am trying to dump the tables and load them into Postgres on a Suse 9.2 
box. I get the following error:
ERROR:  invalid byte sequence for encoding "UNICODE": 0xe5742c

I have tried to set the client encoding to utf-8 on both machines, but 
it does not seem to help. It works fine with LATIN1, but I think I may 
need Unicode (see point 2).



2. The system I am setting up will contain a several tables with names 
and addresses from many countries (Norway, Spain, Denmark, Sweden 
etc.).
   a. Is Unicode the way to go?
   b. Do I need to configure the server in any way, or is this a client 
issue?


Any advice would be great!

Thank you

В списке pgsql-novice по дате отправления
От: Frank Bax
Дата:
От: Tom Lane
Дата:
Сообщение: Re: Encoding woes
FAQ