Page 1 of 1

Base can't display utf8 text from from postgresql

PostPosted: Mon Jun 29, 2015 1:22 pm
by intmail
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 decoding problem. My data are encoded with utf8 and all works fine with pgadminIII (sql editor provided by postgres)
I have already set the properties of OpenOffice Base to support UTF8 and the driver is the one which support wide character.

One things strange is that "tables" panel do not show the list of the tables. The panel is just blank.

Please tell me how to get the right text without squarre characters

Thank you

Re: Base can't display utf8 text from from postgresql

PostPosted: Mon Jun 29, 2015 1:30 pm
by Villeroy
May be Windows line feeds with char(13) :?:

Re: Base can't display utf8 text from from postgresql

PostPosted: Mon Jun 29, 2015 1:37 pm
by intmail
It is not a line feed because data is just a plain text. All caracter are separated with the square symbol like this: w.o.r.d.s

Re: Base can't display utf8 text from from postgresql

PostPosted: Mon Jun 29, 2015 1:49 pm
by acknak
intmail wrote:... All caracter are separated with the square symbol like this: w.o.r.d.s

That looks like UTF-16, not UTF-8. The squares are zero bytes.

If you have a choice when you import into OO, set the encoding to "Unicode" or UTF-16.

If you don't see a place to choose the encoding, tell us what steps you're following to import the text.

Re: Base can't display utf8 text from from postgresql

PostPosted: Mon Jun 29, 2015 4:08 pm
by intmail
The problem is not from importing data because I switch entirely my desktop computer to ms windows then open office base display text correctly without square.
This mean that server and its data are ok.
something goes wrong with oo for linux, odbc driver for linux, configuration of the driver, ...