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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Leland F. Jackson, CPA > Sent: Monday, April 30, 2007 3:23 PM > To: [EMAIL PROTECTED] > 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
