0

In my database there is a field which type is of type "varchar" and it cannot save my alphabet, so the value is for example - "|^є^Ѓ¦`ѓЇ ^єЋ^", and I want to convert it to unicode when I retrieve the data. How canI do that? Is it possible in JavaScript? or vb.net?

IMPORTANT: I do not have access to change the column type in the database.

Jason Aller
  • 3,541
  • 28
  • 38
  • 38
Avtandil Zenaishvili
  • 49
  • 7
  • I don't now how the value was inserted, I just have database where data is save so, I also don't know what encoding is used. I think that it is charged encoding,because database type is varchar – Avtandil Zenaishvili Jul 15 '18 at 15:33
  • Check the `COLLATIONPROPERTY` of that field, and see what CodePage or LCID was used. Then you can use: `Dim OriginalEncoding as Encoding = Encoding.GetEncoding([CodePage])`. – Jimi Jul 15 '18 at 15:47
  • When *you* insert `ႠႡႢაბგ`, what is the result in the database? – daxim Jul 15 '18 at 17:46
  • when I insert `ႠႡႢაბგ` , result in the database is `??????` – Avtandil Zenaishvili Jul 15 '18 at 18:33
  • First task, and only you can do it, it is to find the original encoding. Ask or try decoding with many decoders. Note: Unicode is also just a decoded (so wee it as virtual data). Probably you should also decide in which form (which encoder) you need to put your unicode data. – Giacomo Catenazzi Jul 17 '18 at 13:44

0 Answers0