Encoding problems - MySql backend

[John Ralls]

On Jan 20, 2012, at 5:44 PM, Bernardo Romero wrote:

> I have everything installed in my Windows 7 PC. I have several MySQL applications running out of a local install, but the only one with the change was Gnucash.
> I didn't change anything before the encoding got corrupted.
> 

Please remember to copy the list on all replies (use "Reply All").


That's a little strange. Before 2.4.9, Gnucash would drop all the tables in a DB and recreate them from what was in memory if you used certain features... but it wouldn't drop the database... and if it creates the database, it sets the default character set to UTF-8.

Can you examine the "funny characters" to see how they might have been transcoded? Is there anything in the MySql logs which might indicate what happened? As an aside, the only transcoding in Gnucash that I'm aware of is in the XML backend. Internally it's UTF-8 all the way -- unless there's ASCII in some dark corner that I haven't found yet.

(I expect someone will see this and point out the dark corners shortly after this hits the list. ;-) )

Regards,
John Ralls