getdeb-collaboration team mailing list archive

[João Luís Marques Pinto <joao.pinto@xxxxxxxxxx>]

Matías Manuel Grandi wrote:
> In the spanish version, the characters are broken in all software 
> descriptions. (as far as I read)
>
> 2008/10/19 Christoph Korn <c_korn@xxxxxx <mailto:c_korn@xxxxxx>>
>
>     The characters are not broken in all app descriptions:
>
>     In FileZilla it is not broken:
>     http://img134.imageshack.us/img134/951/unbenanntid4.png
>
>     But in UbuntuTweak it is:
>     http://img134.imageshack.us/img134/9738/unbenannt2pt8.png
>
>     João Luís Marques Pinto schrieb:
>     > Hello,
>     > today I was warned that the apps descriptions translations
>     encoding is
>     > broken for non english characters.
>     > I still need to figure what's wrong since the db was moved with a
>     > plain import/export, until then please do not change or add app
>     > translations, the resolution may required to reimport the table.
>     >
>     > Thanks
>     >
>
>
>     _______________________________________________
>     Mailing list: https://launchpad.net/~getdeb-collaboration
>     <https://launchpad.net/%7Egetdeb-collaboration>
>     Post to     : getdeb-collaboration@xxxxxxxxxxxxxxxxxxx
>     <mailto:getdeb-collaboration@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~getdeb-collaboration
>     <https://launchpad.net/%7Egetdeb-collaboration>
>     More help   : https://help.launchpad.net/ListHelp
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Mailing list: https://launchpad.net/~getdeb-collaboration
> Post to     : getdeb-collaboration@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~getdeb-collaboration
> More help   : https://help.launchpad.net/ListHelp
>   
Hello,
I believe I finally understood what is wrong with the apps description 
and how they got broken.

When changing to UTF-8 all the db tables where set to UTF-8 and the web 
pages encoding also, however the php default connection charset was not 
changed, this means we currently have latin1 encoded strings into utf8 
charset tables.
Because of the current charset use mismatch during the export the 
strings are corrupted.
I have re-exported the app comments table with --default-charset=latin1, 
this fixed at least the languages with more translations.

A proper fix is still missing, the db contents need to be converted to 
UTF8 and it must be set as the default charset for the connections. This 
requires some planning and proper testing, something do be done when 
possible.

Best regards,



--
João Luís Marques Pinto
GetDeb Team Leader
http://www.getdeb.net
http://blog.getdeb.net