I had a similar problem myself and found if I used SQL_ASCHII for the data
base I could insert my data.
I understand however that it basically means the database does not know
anything about encoding and therefore stuff like upper does not work on the
extended chars.
I ended up changing to sql_aschii so both my inserts and backup and restore
work, realizing I am giving up some functionality.
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, IncThis email message is for the use of the intended recipient(s)
andmay
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Markus Schaber
Sent: Tuesday, February 22, 2005 8:41 AM
To: Garry
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] problem inserting local characters ...
Hi, Garry,
Garry schrieb:
> Trying to do this insert, I get an error on both the values
> "TelefonGeschäft" and "Firmenstraße":
>
> FEHLER: ungültige Byte-Sequenz für Kodierung »UNICODE«: 0xe165
This sounds as your database was created in unicode (utf-8).
> (the 0xe165 differs between the two; the fields in question are regular
> type "text" fields)
>
> Looks like I'm having some trouble with unicode encoding ... The
> characters I have are regular 8bit ASCII chars ... How can I fix this?
No, 8bit ASCII does not exist. ASCII always is 7 bit. As your error
message is in German, I suspect your data is encoded in LATIN1 or LATIN9
(their only difference is the EUR symbol in the latter one).
Can you try to add the following command before your insert statements:
set client_encoding to latin1;
HTH,
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com