X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DB3B5293C for ; Wed, 22 Jun 2005 16:36:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96317-04 for ; Wed, 22 Jun 2005 19:36:05 +0000 (GMT) Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by svr1.postgresql.org (Postfix) with ESMTP id A1B3652933 for ; Wed, 22 Jun 2005 16:36:04 -0300 (ADT) Received: from jfradkin ([66.15.127.235]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0III00KFQ3S4JAP4@vms044.mailsrvcs.net> for pgsql-sql@postgresql.org; Wed, 22 Jun 2005 14:36:04 -0500 (CDT) Date: Wed, 22 Jun 2005 15:36:31 -0400 From: "Joel Fradkin" Subject: encoding question To: Message-id: <000001c57761$b195ba40$797ba8c0@jfradkin> MIME-version: 1.0 Content-type: multipart/alternative; boundary="----=_NextPart_000_0001_01C57740.2A841A40" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.792 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: ** X-Archive-Number: 200506/277 X-Sequence-Number: 21878 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C57740.2A841A40 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, =20 I am trying to convert from SQL_ASCII to UNICODE. =20 I have a program that will read from a table in one database and write = to a table in a different database. I am hoping this all I need do (One data base is SQL_ASCII and the = other is UNICODE). I get a byte sequence error writing. I tried using encoding =3DUNICODE and did not get the error, but the = data looked different stored in the field, so I am guessing it messed it up. I am using NpgsqlConnection. Any one know the proper way to convert using a .net app? =20 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. C 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 =20 ------=_NextPart_000_0001_01C57740.2A841A40 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I am trying to convert from SQL_ASCII to = UNICODE.

 

I have a program that will read from a table in one = database and write to a table in a different database.

I am hoping this all I need do (One data base is = SQL_ASCII and  the other is UNICODE).

I get a byte sequence error = writing.

I tried using encoding =3DUNICODE and did not get the = error, but the data looked different stored in the field, so I am guessing it = messed it up.

I am using NpgsqlConnection.

Any one know the proper way to convert using = a .net app?

 

Joel Fradkin

 

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305

 

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 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.

 


 

 

------=_NextPart_000_0001_01C57740.2A841A40--