encoding question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux