Re: [Ext] Re: AWS PostgreSQL Encoding and Connection Issue on JMP - Mailing list pgsql-odbc

P {margin-top:0;margin-bottom:0;}

Hi Hiroshi,

Thank you for getting back to me.  Below is the output of locale:

LANG="en_US.UTF-8"

LC_COLLATE="en_US.UTF-8"

LC_CTYPE="en_US.UTF-8"

LC_MESSAGES="en_US.UTF-8"

LC_MONETARY="en_US.UTF-8"

LC_NUMERIC="en_US.UTF-8"

LC_TIME="en_US.UTF-8"

LC_ALL=

Best regards,

Michiko

---

From: Inoue, Hiroshi <h-inoue@dream.email.ne.jp>
Sent: Monday, June 15, 2020 5:14 AM
To: Michiko Kawamoto <michiko.kawamoto@perfectdayfoods.com>
Cc: pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
Subject: [Ext] 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