[Mono-list] Encoding problems

[Aleksandar Dezelin]

Francisco Figueiredo Jr. wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Hi all,
>
> I received a report about problems with encoding on mono.
>
> The following text isn't being returned correctly from database:
>
> Magriñá
>
> The chars n-tilde and a-acute is appearing as strange chars.
>
> On mono 1.0.4 on linux if you change LANG to en_US the text reads
> correctly, with es_ES not.
>
> I tested here with svn version and with both en_US and es_ES it works.
> Only if I export LANG= it returns wrong chars. What is the default
> encoding when I don't set LANG?
>
> Do you know if there is any problem with 1.0.4 or 1.0.5 and if so if
> there is any fix?
>
> Thanks in advance.

If you want to store non latin strings in a database without using the 
database unicode type you should convert them to latin1 codepage before 
storing it in the database and afterwards convert it to the desired 
codepage after reading it from the database.

Cheers,
Aleksandar Dezelin