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

