From: | Michiko Kawamoto <michiko(dot)kawamoto(at)perfectdayfoods(dot)com> |
---|---|
To: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: [Ext] Re: AWS PostgreSQL Encoding and Connection Issue on JMP |
Date: | 2020-06-15 16:28:04 |
Message-ID: | BYAPR14MB29199081C4585D93B4FD0611829C0@BYAPR14MB2919.namprd14.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)dream(dot)email(dot)ne(dot)jp>
Sent: Monday, June 15, 2020 5:14 AM
To: Michiko Kawamoto <michiko(dot)kawamoto(at)perfectdayfoods(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Inoue, Hiroshi | 2020-06-16 12:12:07 | Re: [Ext] Re: AWS PostgreSQL Encoding and Connection Issue on JMP |
Previous Message | Inoue, Hiroshi | 2020-06-15 12:14:39 | Re: AWS PostgreSQL Encoding and Connection Issue on JMP |