[dba-Tech] Bizarre Font event

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
>



More information about the dba-Tech mailing list