Обсуждение: AWS PostgreSQL Encoding and Connection Issue on JMP
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
Hi Michiko,
I use Mac little unfortunately.
What is the output of locale command?
regards,
Hiroshi Inoue
I use Mac little unfortunately.
What is the output of locale command?
regards,
Hiroshi Inoue
On 2020/06/13 6:59, Michiko Kawamoto wrote:
P {margin-top:0;margin-bottom:0;} 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
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
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
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
Hi,
What is the language for the data?
Could you see the data via psql?
regards,
Hiroshi Inoue
What is the language for the data?
Could you see the data via psql?
regards,
Hiroshi Inoue
On 2020/06/16 1:28, Michiko Kawamoto wrote:
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,MichikoFrom: 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 JMPHi Michiko,
I use Mac little unfortunately.
What is the output of locale command?
regards,
Hiroshi InoueOn 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