Re: AWS PostgreSQL Encoding and Connection Issue on JMP

Hi Michiko,

I use Mac little unfortunately.
What is the output of locale command?

regards,
Hiroshi Inoue

On 2020/06/13 6:59, Michiko Kawamoto wrote:
> Hello psqlODBC team,
>
> We have a PostgreSQL instance on AWS.  I would like to make a
> connection to the database on JMP. I installed the ODBC driver via
> Homebrew (I am on Mac Catalina) and set up DSN with psqlodbca.so
> driver.  I was able to make a connection to the db successfully, but I
> noticed that the first 2 rows had encoding issues, so I thought that I
> should switch over from psqlodbca.so to psqlodbcw.so driver since the
> db encoding is UTF-8.  When I use the psqlodbcw.so driver, it's not
> able to connect to the db.
>
> * JMP® 15.0.0
> * macOS Catalina Version 10.15.5
> * Driver path: /usr/local/Cellar/psqlodbc/12.01.0000/lib/psqlodbcw.so
>
> I would greatly appreciate your feedback.
>
> Thank you,
> Michiko