From: | Андрей Шиканов <itshikanow(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | |
Date: | 2020-09-30 11:07:31 |
Message-ID: | CAOzR+2T+zWM5HWEmkYvUQdW52iToeofkoDPkHEzmF4Sv9MCcfA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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!
--
Андрей Шиканов
From | Date | Subject | |
---|---|---|---|
Next Message | Daniil Megrabyan | 2020-10-02 11:57:11 | How to release savepoints properly |
Previous Message | Javier Partida | 2020-09-24 11:33:29 | [Driver] Compilation of psqlodbc-09.03.0400 |