From: "Joel Fradkin" <jfradkin@wazagua.com>
To: "'John DeSoi'" <desoi@pgedit.com>
Cc: <aarni@kymi.com>, <pgsql-sql@postgresql.org>
Subject: 
 =?iso-8859-1?Q?RE:_=5BSQL=5D_RE:_=5BSQL=5D_trrouble_inserting_stuff_lik?=
	=?iso-8859-1?Q?e_=E9?=
Date: Fri, 18 Feb 2005 16:03:11 -0500
Message-ID: <000001c515fd$42ade910$797ba8c0@jfradkin>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
In-reply-to: <986DAB00-81ED-11D9-9C09-000A95B03262@pgedit.com>

I did that and it did not work.
On the .net driver I had to do it on the connect string.

I also just tested latin and see the lower and upper do not work on the
French chars, while upper and lower do work on the French chars on a =
Unicode
database. So the problem is getting the odbc driver to work with =
Unicode.
Worst case I will just use SQL_ASCHII, I am guessing the ODBC driver =
does
not have a encoding command like the .net one does.

Joel Fradkin
=20
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305
=20
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
=A9 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.  Any unauthorized =
review,
use, disclosure or distribution is prohibited.  If you are not the =
intended
recipient, please contact the sender by reply email and delete and =
destroy
all copies of the original message, including attachments.
=20

=20

-----Original Message-----
From: John DeSoi [mailto:desoi@pgedit.com]=20
Sent: Friday, February 18, 2005 3:42 PM
To: Joel Fradkin
Cc: aarni@kymi.com; pgsql-sql@postgresql.org
Subject: Re: [SQL] RE: [SQL] trrouble inserting stuff like =E9


On Feb 18, 2005, at 11:15 AM, Joel Fradkin wrote:

> How do I tell the connection to use Unicode?

Try

SET client_encoding TO 'UNICODE';

http://www.postgresql.org/docs/8.0/interactive/sql-set.html

But it should default to the database encoding, so I'm not sure if that=20
is the problem.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL