I'm getting the following error from a query being generated from MS
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
> forms which will invariably contain Microsoft's proprietary
> characters such as 'smart' quotes, trademark, copyright symbols,
> grave, etc. We've set the HTML pages as UTF-8 and the database
> UTF-8. However when our calls to import the data that includes any
> characters into the database, the queries fail complaining that e.g.
> "[nativecode=ERROR: character 0xe28093 of encoding "UTF8" has no
> 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;
tigris=# show client_encoding;
What else should I be looking at?
Chief Technology Officer
Meridias Capital Inc
pgsql-admin by date
|Next:||From: Elim Qiu||Date: 2007-05-03 20:23:21|
|Subject: install pgSQL from no-installer pkg|
|Previous:||From: kannan kk||Date: 2007-05-03 17:12:31|
|Subject: Request regarding my login information|