Connecting Tech Pros Worldwide Forums | Help | Site Map

OpenOffice.org, PostgreSQL and Unicode

Newbie
 
Join Date: Oct 2009
Posts: 3
#1: Oct 11 '09
I have a PostgreSQL database encode in UTF-8. I try to do a mail merge from OOwriter. This seems to work except for non western characters. E.g. when I access the database from pgAdmin, a GUI client I can see all UTF-8 encoded characters. When I cut a text from the GUI and paste this text in OOwriter everything works well. The same text through a mail merge only shows question marks. An example:
---------------
เมืองไทย

TH
Thailand
????????
---------------
The first line is cut from pgAdmin and pasted into OOwriter. The other lines the mail merge. The ?????? should be เมืองไทย .

First I thought I could correct this by setting:

Database->open and existing database file->right click to go to "database properties"->set Data conversion character set to "Unicode (UTF-->save)

but that doesn't help. Then on this site I read the question and answer on:
http://bytes.com/topic/postgresql/answers/857378-client-encoding-postgresql so I thought that might have somethig to do with it. But I can't find something like a client_encoding setting in OpenOffice Base.

Any help would be really appreciated.

Member
 
Join Date: Dec 2006
Location: Spain, Galiza, Ferrol
Posts: 48
#2: Oct 16 '09

re: OpenOffice.org, PostgreSQL and Unicode


it's up of the driver, try another : postgresql sdbc is a native one for open office, odbc, jdbc...

The odbc package has two drivers : ANSI and Unicode

I tried odbc and sdbc and both workerd for me with an UTF-8 db
Newbie
 
Join Date: Oct 2009
Posts: 3
#3: Oct 16 '09

re: OpenOffice.org, PostgreSQL and Unicode


Unfortunately these drivers are Windows/Linux only. I need OS X. Sure I can build them from source but I will only do that as a last resort. A few days ago I purchased a driver from Actualtechologies for OS X and that driver doesn't work with UNICODE UTF-8.

Thanks for the response anyway.
Reply

Tags
base, openoffice, postgresql, unicode, utf-8


Similar PostgreSQL Database bytes