codepage ANSI_X3.4-1968.:

[cooljl31]

Hi i'm have some issue with this adapter. Have you any idea what can cause this issues

I'm using the DSN to connect to Exasol and it successfully connected
in the rails console i can call my Company.count and i get the number of rows in the database but when i Company.where(company_id: 2222) i get this error

info:
rails 5
ruby 2.4.1
i'm user docker for development

ActiveRecord::StatementInvalid: ODBC::Error: S1000 (1) [EXASOL][EXASolution driver]Character set conversion error or output buffer to small: Invalid or incomplete multibyte or wide character column 5, cursor position 1, codepage ANSI_X3.4-1968.:

[ziggythehamster]

Some ODBC drivers are dependent on the system's configured locale. When it's not configured, your system locale probably looks like this (use the locale command to check):

LANG=
LANGUAGE=
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

This means a locale isn't configured. Many drivers therefore will default to ANSI_X3.4-1968, which is often not supported.

You need to configure your system locale. (So do I :))