Yes, that did the trick... I tried to execute the same statement at the same time as I did the insert, but it needed to be in a separate statement.... Thx.... :) BTJ John DeSoi wrote: > > On Jul 24, 2005, at 1:52 PM, Bjørn T Johansen wrote: > >> I don't think you are correct... UTF-8 might be default on MSSQL, but >> it is the ODBC >> connection to PGSQL that sets the client encoding to UTF-8... (I.e. >> when I just connect to >> the PGSQL server, I get a statement in the PG log file that says "set >> client_encoding to >> 'UTF8'.. >> >> And I don't want to use UNICODE on my PG Server.... > > > > After you login try executing "SET client_encoding TO LATIN1" > > I don't use ODBC so I don't know if this will mess things up, but it > might be worth a try. > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
