hello. Cyrilic Characters truncate with ODBC driver. UTF-8
Here is postgresql table
id | bigint | | | nextval('accounts_id_seq'::regclass)
last_name | character varying(40) | | |
first_name | character varying(120) | | |
id last_name
1 | ТЕСТИРУЕМ_ОДБС_ДРАЙВЕР_НА_КОЛИЧЕСТВО
odbc.ini config
[main]
Description = PostgreSQL connection to norma
Driver = PostgreSQL Unicode
Database = odbc_test
Servername = server
UserName = user
Password = passwd
Port = 5432
Protocol = 12
ReadOnly = Yes
RowVersioning = No
ShowSystemTables = No
ConnSettings =
MaxCharSize = 2000000
MaxVarcharSize = 2000000
MaxLongVarcharSize = 2000000
FetchBufferSize = 99
UseUnicode= Yes
UnknownSizes= Longest
MaxVarchar= 65534
MaxLongVarChar= 65534
DriverUnicodeType=1
TextAsLongVarchar=1
BoolsAsChar = No
MaxVarcharSize = 0
Testing:
isql -v main
>SELECT name, setting FROM pg_settings WHERE category ~ 'Locale';
server_encoding UTF8
> select last_name from odbc_test where id=1;
| last_name |
+-----------------------------------------+
| ТЕСТИРУЕМ_ОДБС_ДРАЙВЕ|
The result is only part of last_name!
--