r19200 - gnucash/trunk/src/backend/dbi - Fix #616100 - Incorrect character set used in MySQL backend

[Phil Longstaff]

On Mon, 2010-05-24 at 10:24 -0400, Derek Atkins wrote:
> Phil,
> 
> What about existing databases?  Don't you need some sort of
> conversion?
> 
> -derek
> 
> Phil Longstaff <plongstaff at code.gnucash.org> writes:
> 
> > Author: plongstaff
> > Date: 2010-05-22 17:29:00 -0400 (Sat, 22 May 2010)
> > New Revision: 19200
> > Trac: http://svn.gnucash.org/trac/changeset/19200
> >
> > Modified:
> >    gnucash/trunk/src/backend/dbi/gnc-backend-dbi.c
> > Log:
> > Fix #616100  - Incorrect character set used in MySQL backend
> >
> > Use "SET NAMES 'utf8'" so that mysql uses utf8 for communication and all char sets.

Derek, I can't believe you're top posting ;)

In any case, no.  SET NAMES seems to just tell the mysql server that the
char set for all communication with the client is UTF8.  It doesn't
affect the database ifself.

Phil