[SQL] encoding

[Joel Fradkin]

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