Encoding problems - MySql backend

[Bernardo Romero]

> 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.
>
>
>
>
>
> El 20 de enero de 2012 16:16, John Ralls <jralls at ceridwen.us> escribió:
>
>
>> On Jan 20, 2012, at 12:58 PM, Bernardo Romero wrote:
>>
>> > Hello everyone,
>> >
>> > Today, without having made any changes to my PC, I started having funny
>> > characters where accented Spanish characters used to be. It looks like
>> at
>> > least one of the server/schema/table/field collation settings was
>> corrupted
>> > at some point. However, everything looks correctly set to
>> UTF8_general_CI.
>> > I will try and change the characters back using SQL, but I wanted to
>> know
>> > whether somebody had this kind of problem before.
>> >
>> > I'm using Gnucash 2.4.6 with a MySQL server 5.1.42
>>
>> We saw a similar problem a few weeks ago with a new MySQL database which
>> had been created with the default encoding (which is swedish-latin1). We
>> don't know why, but this doesn't work: The DB must be created with utf-8
>> for the encoding.
>>
>> In your case, though, it was an existing DB and nothing at all changed
>> either with the server or Gnucash, correct?
>>
>> Regards,
>> John Ralls
>>
>>
>
>
> --
>
> Cordialmente,
>
>
>
> Bernardo Romero C.
>
> *Socio Gerente*
>
> *Scalaria - Consultores de Negocios*
>
> (57) 317 331 5203
>
> bromero at scalaria.co
>
> www.scalaria.co
>
>
>
> Considere su responsabilidad ambiental antes de imprimir este correo
> electrónico.
>
> Scalaria: comprometida con el medio ambiente
>
>


-- 

Cordialmente,



Bernardo Romero C.

*Socio Gerente*

*Scalaria - Consultores de Negocios*

(57) 317 331 5203

bromero at scalaria.co

www.scalaria.co



Considere su responsabilidad ambiental antes de imprimir este correo
electrónico.

Scalaria: comprometida con el medio ambiente