"Kevin McCarthy" <kemccarthy1@gmail.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