Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4FCD79FA690 for ; Thu, 3 May 2007 17:11:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 11159-10 for ; Thu, 3 May 2007 17:11:30 -0300 (ADT) X-Greylist: delayed 00:25:54.622845 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 281309FB414 for ; Thu, 3 May 2007 17:11:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from atherton-ex-02.meridias.local (exchange.meridiascapital.com [65.90.55.79]) by svr4.postgresql.org (Postfix) with ESMTP id A367F5AF889 for ; Thu, 3 May 2007 19:45:39 +0000 (GMT) Received: from [192.168.11.11] ([192.168.11.11]) by atherton-ex-02.meridias.local with Microsoft SMTPSVC(6.0.3790.1830); Thu, 3 May 2007 13:45:29 -0600 Mime-Version: 1.0 (Apple Message framework v752.3) To: pgsql-admin@postgresql.org Message-Id: Content-Type: multipart/alternative; boundary=Apple-Mail-1-198349514 From: Warren Little Subject: encoding question Date: Thu, 3 May 2007 13:45:28 -0600 X-Mailer: Apple Mail (2.752.3) X-OriginalArrivalTime: 03 May 2007 19:45:29.0898 (UTC) FILETIME=[9ACE98A0:01C78DBB] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/39 X-Sequence-Number: 25359 --Apple-Mail-1-198349514 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed 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" 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 --Apple-Mail-1-198349514 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1
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=3DERROR:=A0 = 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.=A0 Beware that you need the server's locale
settings to be in step, too.

regards, tom lane

---------


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

and

tigris=3D# 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


=

= --Apple-Mail-1-198349514--