Latin1 characters in sql scripts

From: "Rick Szeto" <rszeto(at)csi(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Latin1 characters in sql scripts
Date: 2002-10-25 15:19:29
Message-ID: sdb928da.072@mail.tor.csi.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I am having a problem with writing some scripts that will populate an
application because it has french characters. I already have my db
instance as LATIN1.

My question is this: How can I escape the 'special' characters?
Like this 0x00CE?
or
Like this \u00CE?

Any help would be greatly appreciated.
Rick

Browse pgsql-novice by date

  From Date Subject
Next Message Rikard Neidenmark 2002-10-25 15:42:04 show all tables?
Previous Message Tom Lane 2002-10-25 14:11:40 Re: function problems.