show client_encoding gives: UNICODE databases reads: DATABASE OWNER ENCODING mydb david UNICODE testdb david SQL_ASCII
table columns are character varying(255) Tx, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Huxton Sent: 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 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) - Kloten', 'ZRH' ) ; > > > I get: > > psql:airport_codes.sql:1728: ERROR: Invalid UNICODE character sequence > found (0xfc7269) > > Obviously I'd like to keep the proper German spelling. What is your client encoding? (look into "show client_encoding", "\encoding" in the "Localization" chapter of the manuals) -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings --- --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.771 / Virus Database: 518 - Release Date: 9/28/2004 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
