node-sybase icon indicating copy to clipboard operation
node-sybase copied to clipboard

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

Open davidsanchezcoloma opened this issue 3 years ago • 2 comments

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!

davidsanchezcoloma avatar Mar 18 '21 12:03 davidsanchezcoloma

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

lroal avatar Aug 10 '21 12:08 lroal

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.

davidsanchezcoloma avatar Aug 12 '21 07:08 davidsanchezcoloma