| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-04-26 14:40:02 | Re: Encoding woes |
| Previous Message | Frank Bax | 2005-04-26 14:03:15 | Re: calling perl program within a cgi script with |