From: Joel Fradkin <jfradkin@wazagua.com>
To: pgsql-sql@postgresql.org
Subject: encoding
Date: Fri, 6 May 2005 09:50:06 -0400
Message-ID: <000001c55242$82e0fff0$797ba8c0@jfradkin> (raw)
I am not clear on what makes this work?
I am going live Sunday and have thus far been using SQL_ASCHII.
I still have the feeling I should be using something else, but when I used
Unicode my conversion from MSSQL blew up on encoding error for a char that
wasn't plain ASCHII(IE French or Spanish etc.).
The conversion program ran fine when I chose SQL_ASCHII.
The data is on a windows 2k MSSQL database.
The conversion program is a .net app that reads from MSSQL win2k data base
and writes to postgtres 8.0.2 on Redhat AS4.
I tried to get this to work a while back and found if I set the encoding
explicitly on the connect in the .net connector it did not give me an error,
but I still have many asp pages and I could not get the encoding set using
the ODBC (which is what the asp pages use).
I believe I tried setting it with a sql statement, but that did not seem to
help either.
I can move forward using SQL_ASCHII, but would prefer to have encoding set
properly, but I ma not sure what I am missing.
Any ideas would be much appreciated.
Joel Fradkin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jfradkin@wazagua.com
Subject: Re: encoding
In-Reply-To: <000001c55242$82e0fff0$797ba8c0@jfradkin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox