Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group