Re: encoding question

fyi,
I upgraded the odbc driver on the client and every thing worked.

thanks

On May 3, 2007, at 1:45 PM, Warren Little wrote:

> 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
>
>
>

Warren Little
Chief Technology Officer
Meridias Capital Inc
ph 866.369.7763