Peter Brawley
peter.brawley at earthlink.net
Sun Mar 17 19:57:21 CDT 2013
On 2013-03-17 1:15 PM, Arthur Fuller wrote: > I'm working with a guy in San Francisco. The app is Access + MySQL back > end. We use a cool MySQL IDE called Navicat, one of whose virtues is easy > backups. > > I did a little demo app of some concepts we're exploring vis-a-vis his big > app. I sent my colleague a zip containing the Access FE and the MySQL > backup. He restored it on his server, set up a DSN and ran the demo. > > The demo works fine, in terms of functionality. But for some reason, some > of the text fields are displayed in Chinese characters. An examination of > the tabledefs within Access reveals that Access thinks these fields are > binary, when in fact they are just text. How this happened, or in which > piece of software, I have no idea. The short answer is, to avoid MySQL charset hell do everything (database, app, /everything/) in UTF8. For the longer answer see http://www.bluebox.net/about/blog/2009/07/mysql_encoding/. PB ----- > > Has anyone ever seen this sort of behaviour before? Or know what can be > done to fix it? > > TIA, > Arthur > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >