Skip site navigation (1) Skip section navigation (2)

Encoding woes

From: Bendik R(dot)Johansen <bendik(dot)johansen(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Encoding woes
Date: 2005-04-26 14:15:09
Message-ID: a496e56c5617140d93963277d29bcef7@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-04-26 14:40:02
Subject: Re: Encoding woes
Previous:From: Frank BaxDate: 2005-04-26 14:03:15
Subject: Re: calling perl program within a cgi script with

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group