encoding: square characters seen in openoffice base with postgresql 9.3 - Mailing list pgsql-odbc

From intmail01@gmail.com
Subject encoding: square characters seen in openoffice base with postgresql 9.3
Date
Msg-id 55911230.1060504@gmail.com
Whole thread Raw
List 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 p, li { white-space: pre-wrap; }

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

pgsql-odbc by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Compiling on Haiku with iODBC
Next
From: "intmail01@gmail.com"
Date:
Subject: utf8 data with strange characters