Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Problem with special character encoding (Possibly Latin1)

Hi there,   So, I got a database that possibly has a Latin1 encoding for the text fields. I say possibly because it's a DB that's not being supported that well anymore by the original designers and...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    try writing like this:
    Text.FromBinary(....... , 1252)
    Text.FromBinary(....... ,TextEncoding.Utf8)

    Text.FromBinary(Text.ToBinary([Column1],1252),TextEncoding.Utf8))
    maybe you will need another unicode :

    Text.FromBinary(....... , 1145)
    Text.FromBinary(....... ,TextEncoding.Utf8)

    Text.FromBinary(Text.ToBinary([Column1],1145),TextEncoding.Utf8))
    or

    Text.FromBinary(....... , 1256)
    Text.FromBinary(....... ,TextEncoding.Utf8)

    Text.FromBinary(Text.ToBinary([Column1],1256),TextEncoding.Utf8))

     


     

Ahmedx's avatar
Ahmedx
Super User
3 years ago

try writing like this:
Text.FromBinary(....... , 1252)
Text.FromBinary(....... ,TextEncoding.Utf8)

Text.FromBinary(Text.ToBinary([Column1],1252),TextEncoding.Utf8))
maybe you will need another unicode :

Text.FromBinary(....... , 1145)
Text.FromBinary(....... ,TextEncoding.Utf8)

Text.FromBinary(Text.ToBinary([Column1],1145),TextEncoding.Utf8))
or

Text.FromBinary(....... , 1256)
Text.FromBinary(....... ,TextEncoding.Utf8)

Text.FromBinary(Text.ToBinary([Column1],1256),TextEncoding.Utf8))

 


 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you so much Ahmedx!! You're a genius!

     

    1252 did the trick. The only weird thing was, it was the first one I tried and it didn't seem to work. Even rotated through the output encoding (utf-8, windows, and others). Finally, I tried the 1251 and utf-8 combination again and suddenly it worked. Don't know if there was something cached before or whatever.