Hi, David,
On Thu, 11 Nov 2004 11:29:22 -0800
"David B" <[EMAIL PROTECTED]> wrote:
> show client_encoding gives:
> UNICODE
So is the data you send also encoded in unicode?
Maybe "set client_encoding latin1" or "\encoding latin1" helps.
HTH,
markus
--
markus schaber | dipl. informatiker
logi
David B wrote:
show client_encoding gives:
UNICODE
databases reads:
DATABASE OWNER ENCODING
OK - with the same settings here, I start psql and do:
\i unicode_import_test.txt
I get:
CREATE TABLE
t
-
AAA
À È Ð Ø
ZZZ
(3 rows)
In case this gets garbled by my email, the middle line cont
: Wednesday, November 10, 2004 10:34 AM
To: David B
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Unicode problem inserting records - Invalid UNICODE
character
David B wrote:
> My first time using unicode. Based on reading other messages I think I've
> got it all setup correctly but stil
David B wrote:
My first time using unicode. Based on reading other messages I think I've
got it all setup correctly but still have prob.
Running: psql 7.3.6-RH
[snip]
For both I get the same results when I try to:
INSERT INTO airport_code ( airport_name, airport_code ) values ( 'Zurich
(Zürich) - K
My first time using unicode. Based on reading other messages I think I've
got it all setup correctly but still have prob.
Running: psql 7.3.6-RH
$ psql -l
List of databases
Name| Owner | Encoding
---+--+---
devdb | devuser | UNICODE
template0 | pos
