pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Warren Little <Warren.Little@MeridiasCapital.com>
To: pgsql-admin@postgresql.org
Subject: encoding question
Date: Thu, 3 May 2007 13:45:28 -0600
Message-ID: <EE41CBAF-18CE-470F-9D5F-5483FAB60FB3@MeridiasCapital.com> (raw)

I'm getting the following error from a query being generated from MS  
Access :
character 0xefbfbd of encoding "UTF8" has no equivalent in "LATIN9"

Upon reviewing the archives I found the following:

"Kevin McCarthy" <kemccarthy1 ( at ) gmail ( dot ) com> writes:
 > Often users will copy and paste text directly from MS Word docs  
into the
 > forms which will invariably contain Microsoft's proprietary  
formatting of
 > characters such as 'smart' quotes, trademark, copyright symbols,  
accent
 > grave, etc. We've set the HTML pages as UTF-8 and the database  
connection to
 > UTF-8. However when our calls to import the data that includes any  
of these
 > characters into the database, the queries fail complaining that e.g.
 > "[nativecode=ERROR:  character 0xe28093 of encoding "UTF8" has no  
equivalent
 > in "LATIN9"]"

That error suggests that your database encoding is LATIN9, not UTF-8.
You need to change it.  Beware that you need the server's locale
settings to be in step, too.

regards, tom lane

---------


So I ran
tigris=# show server_encoding;
server_encoding
-----------------
UTF8
(1 row)

and

tigris=# show client_encoding;
client_encoding
-----------------
UTF8
(1 row)


What else should I be looking at?

thanks

Warren Little
Chief Technology Officer
Meridias Capital Inc
ph 866.369.7763

view thread (10+ messages)  latest in thread

Message-ID: <EE41CBAF-18CE-470F-9D5F-5483FAB60FB3@MeridiasCapital.com>
Permalink:  ../EE41CBAF-18CE-470F-9D5F-5483FAB60FB3@MeridiasCapital.com/
Also on:    postgresql.org/message-id/EE41CBAF-18CE-470F-9D5F-5483FAB60FB3@MeridiasCapital.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Warren.Little@MeridiasCapital.com
  Subject: Re: encoding question
  In-Reply-To: <EE41CBAF-18CE-470F-9D5F-5483FAB60FB3@MeridiasCapital.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox