Open ErikJansenIRefact opened 1 year ago
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Please re-open.
Hi, any solution?
Hi,
The test environment setup:
Database has a single table:
Tested connection to the database with isql (command line tool) and issued the following statement:
Tested connection with nodejs and issued the same statement as above on the connection:
Ran both statements above (via isql and with nodejs) with odbc debug enabled.
[ODBC][47379][1679320146.155152][SQLAllocHandle.c][395] Entry: Handle Type = 2 Input Handle = 0x7f987c815200 UNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UCS-2-INTERNAL'
[ODBC][46268][1679319075.820124][SQLAllocHandle.c][395] Entry: Handle Type = 2 Input Handle = 0x7f8a88012600 UNICODE Using encoding ASCII 'US-ASCII' and UNICODE 'UCS-2-INTERNAL'
It seems that the locale settings are not applied when connecting via NodeJS odbc to the driverManager. The locale settings are:
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=