Hmmmm.... I am using PostgreSQL v-8.1, and in two of my databases I am
using UTF8, although my main database is ASCII-SQL. I have had no problem
whatever hitting the PostgreSQL tables with updateable views via ODBC. When
I alter the table contents, then fire a commit, the changes are applied
quickly. I am, however, running VFP9 (I never really did much with VFP8)
for my applications and test environments. I do not see how that could be
the difference. I am assuming you are not trying to connect to PostgreSQL
after logging onto Windows as "administrator". Apparently that is not
allowed.
Sorry I could not be of more help, other than affirming that VFP ought to
work just fine with UTF8 against PostgreSQL. I am still flogging my way
through the world of PostgreSQL. But every time I use it I find more
reasons to appreciate and enjoy it.
BTW, I found the recently released PostgreSQL For Windows book (I got it
from Amazon) to be an excellent resource. Not quite as good as "A Hacker's
Guide To VFP6/7", but quite excellent in its own right.
Regards,
Gil
> -----Original Message-----
> From: profoxtech-bounces at leafe .D.OT com
> [mailto:profoxtech-bounces@leafe.com]On Behalf Of Leland F. Jackson, CPA
> Sent: Monday, April 30, 2007 3:23 PM
> To: profoxtech at leafe .D.OT com
> Subject: VFP to PostgreSQL connection
>
>
> As of PostgreSQL version 8.1, I'm no longer able to connect to a
> PostgreSQL database that uses encoding UTF8, previously encoding
> Unicode, from a VFP8 client. Has anyone else hit this problem? Has
> this problem been address in VFP9?
>
> The error message is "client encoding mismatch" which is probably caused
> by VFP8 not supporting UTF8 encoding. About all I can do with an ALTER
> DATABASE command is change the name of the database.
>
> I could do a pg_dump backup of the UTF8 PostgreSQL database, then DROP
> it, and then create a ASCII database, and then restore from the
> pg_dump. Anyone else hit up against this problem, or know if this will
> work, or know of a better suggestion.
>
> Regards,
>
> LelandJ
>
>
[excessive quoting removed by server]
©2007 mrgmhale |
