Page 1 of 1

Problem with accent in ODBC Postgresql in Excel

Posted: Tue 12 Oct 2021 14:31
by armmax
Hello
I used the ODBC Postgresql driver to connect to my database in Excel on Mac.
The problem I have is that the accent do not appear properly
For instance, "José" appears as "Jos√©"

What should I change to get accent properly?

Re: Problem with accent in ODBC Postgresql in Excel

Posted: Wed 13 Oct 2021 12:23
by evgeniym
Hi
Unfortunately, we were unable to reproduce the described behavior.
Could you please clarify the encoding of the database and also kindly provide in the DDL script to create and populate the test database. Please send them through the form on our website: https://devart.com/company/contactform.html

Regards,
Evgeniy