Re: [Ext] Re: AWS PostgreSQL Encoding and Connection Issue on JMP

Hi,

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:
> 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
>