You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Im using options.encoding = 'WIN1252' to try retrieve column 'ENDERECO' from my database that contains special characters like "cuiába", very common here in Brazil.
But when i use the regular select: database.query("SELECT ENDERECO FROM CONTATOS").
This return weird character like "cui�ba".
Just work when i use CAST() inside select like: database.queryAsync("SELECT cast(ENDERECO as varchar(100) character set win1252) FROM CONTATOS")
But i have to many colmuns to do this way, someone know how to solve this?.
The text was updated successfully, but these errors were encountered:
Im using
options.encoding = 'WIN1252'
to try retrieve column 'ENDERECO' from my database that contains special characters like "cuiába", very common here in Brazil.But when i use the regular select:
database.query("SELECT ENDERECO FROM CONTATOS").
This return weird character like "cui�ba".
Just work when i use CAST() inside select like:
database.queryAsync("SELECT cast(ENDERECO as varchar(100) character set win1252) FROM CONTATOS")
But i have to many colmuns to do this way, someone know how to solve this?.
The text was updated successfully, but these errors were encountered: