From: | "intmail01(at)gmail(dot)com" <intmail01(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | encoding: square characters seen in openoffice base with postgresql 9.3 |
Date: | 2015-06-29 09:38:56 |
Message-ID: | 55911230.1060504@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
I use linux system as desktop and another one for server which runs
postgresql 9.3
When connecting with openoffice 4.1.1 Base, select syntax returns text
separated by a strange square character.
It seems to be a coding fault. My data are encoded with utf8 and all
works fine with pgadminIII
I have already set the properties of OpenOffice Base to support UTF8.
The version of my driver is 09.03.0400
Please tell me how to get the right text without squarre characters
Bellow are the configuration of odbc.ini
[ODBC Data Sources]
postgre = /usr/local/lib/psqlodbcw.so
[postgre]
DSN=postgre
Driver=/usr/local/lib/psqlodbcw.so
Description=PostgreSQL ODBC remote access
Servername=10.0.0.1
Username=postgres
Password =
Database=xyz
ReadOnly=No
ReadOnly=no
Servertype=postgres
Port=5432
;Socket = 4096
FetchBufferSize=99
ServerOptions=
ConnectOptions=
Options=
Trace=1
TraceFile=/var/log/odbc.sql.log
Debug=1
DebugFile=/var/log/odbc.debug.log
CommLog=1
;Options = 3
Protocol = 6.4 # 7.2 or other values
From | Date | Subject | |
---|---|---|---|
Next Message | intmail01@gmail.com | 2015-07-09 13:08:15 | utf8 data with strange characters |
Previous Message | Michael Paquier | 2015-06-29 00:31:05 | Re: Compiling on Haiku with iODBC |