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!

--
Андрей Шиканов

Browse pgsql-odbc by date

  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