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
a. Is Unicode the way to go?
b. Do I need to configure the server in any way, or is this a client
Any advice would be great!
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-04-26 14:40:02|
|Subject: Re: Encoding woes |
|Previous:||From: Frank Bax||Date: 2005-04-26 14:03:15|
|Subject: Re: calling perl program within a cgi script with|