Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Especial Characteres #87

Open
gmferreir1 opened this issue Dec 14, 2018 · 4 comments
Open

Especial Characteres #87

gmferreir1 opened this issue Dec 14, 2018 · 4 comments

Comments

@gmferreir1
Copy link

special characters are appearing with �
words with the letters ç é º
how to solve this problem

@mreis1
Copy link

mreis1 commented Apr 12, 2019

I have a similar issue, but as far as I know, this only impacts me in currency symbols such as €.
For example: I'm able to retrieve information stored as follows: SALºÓòéç'N exactly the same way in UTF8 (Database ISO8859-1).

But when I request the € symbol, I receive a non representative symbol in UTF8.
If I convert that symbol to hex I get 'c2 80'

Buffer.from('c280','hex').toString() gives me ' '
Then I tried to use iconv.
iconv.decode(Buffer.from(currency.symbol, 'utf8'), 'WINDOWS-1252')
where currency.symbol is actually the value received from the database.
The conversion results in: €
Close but not correct enough. I can't understand why there's an extra 'c2' at the beginning of the field value. ANSI represents € as 0x80.

Here are some screenshots.

image

image

image

@xdenser
Copy link
Owner

xdenser commented Apr 13, 2019

I think here the problem either in libfbclient or in nodejs. I do not do any special charset conversions....

@mreis1
Copy link

mreis1 commented Apr 15, 2019

@xdenser Thank you for the clarification 👍

@mjschutz
Copy link
Contributor

I guess this is related to #9

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants