Unicode question

From: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Unicode question
Date: 2003-04-29 18:30:19
Message-ID: a05210601bad4753525ae@[192.168.0.14]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have created a db WITH ENCODING = 'unicode'.
I have SET CLIENT_ENCODING TO 'unicode'.
Is there anything else I can set to force communication in unicode?

My problem is as follows: I'm making a client application which
functions entirely in unicode utf-8. However, when I write strings
containing accented characters, with INSERT to VARCHAR or TEXT
fields, these characters end up stored as garbage.

This can mean only two things (after narrowing down the problem for 2
days). either the client doesn't write the information to psql in
unicode, or psql (7.3.2) expects something else than unicode.

The support people from my programming environment assure me the
information is being sent as unicode.

That's why I would like to know for sure whether the settings
mentioned above are enough to make psql expect its incoming strings
as unicode. (Or whether there is a known bug around.)

Thanks,

Marc

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-04-29 19:51:32 Re: Looking at PostgreSQL as alternative to MS SQL Server 2000
Previous Message ghaverla 2003-04-29 16:57:57 Re: Looking at PostgreSQL as alternative to MS SQL Server 2000