[ADMIN] Going from a DB using SQL_ASCII to UNICODE

Hi - We are running PostgreSQL 7.1.4, and are finally upgrading... to 7.4.2. While we do this upgrade, we also want to make create our DB as UNICODE (we are having problems with SQL_ASCII where we get a bunch of ? marks). When we try to import the data from a SQL_ASCII dumped db, into the new U

Re: [ADMIN] Going from a DB using SQL_ASCII to UNICODE

Tom, I will try to add "set client_encoding = sql_ascii;" and pray :) Cheers, Dion > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, April 19, 2004 9:21 PM > To: Dion Almaer > Cc: [EMAIL PROTECTED]; 'Lloyd Benson';