search

rodhoward / node-sybase

23 stars 55 forks source link

Not beeing able to insert/update on a ISO-8559-1 charset db #34

Open davidsanchezcoloma opened 3 years ago

davidsanchezcoloma commented 3 years ago

Good morning everyone,

I'm not beeing able to use a database that is actually using ISO-8559-1 as the encoding charset. I have changed the encoding part of SybaseDB.js from utf8 to "binary" and now i'm beeing able to read from database, but still not able to inject any data with insert or update, as the characters are not beeing correctly saved:

image

Any advide on dealing with this problem? I have try to encode the text directly with iconv-lite, but it didn't work.

Thank you!

lroal commented 3 years ago

Do you know the status of this issue ? Will #36 solve the problem ?

davidsanchezcoloma commented 3 years ago

Do you know the status of this issue ? Will #36 solve the problem ?

I see the fix and i tried the same change on my own, and is not fixed. I still get all the "Ñ" and "áéíóú" with a unknown symbol. I changed the .jar for a new implementation on GO language with the same output as the original, so i can use the module just changing the exec (Also i get rid of Java with this), and now is working, but no with that fix.