Forum Discussion

Ayupchap's avatar
Ayupchap
Icon for Helper III rankHelper III
8 years ago

ODBC Error - Not sure how to resolve it

Hi all   OK so I am getting this error with an SQL query:   Details: "ODBC: ERROR [22P05] ERROR: character with byte sequence 0xe2 0x80 0x8e in encoding "UTF8" has no equivalent in encoding "WIN1...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conseguimos resolver da seguinte forma.

 

Driver={PostgreSQL Unicode(x64)}; Server= IP do servidor ; Port= Nome da porta; Database= Nome do Bando de dados

 

Colocando isso na conexão do ODBC, e mudei o DNS do usuário colocando unicode, e no DNS do sistema para Unicode também.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

This solution solved the problem for me! Fortunately, I can read Spanish. lol. Install the PostgreSQL ODBC for Unicode(x64) and use that one instead when connecting to the DB. In my case, I was trying to connect to AWS Cloud version of PostgreSQL in Supabase.