Postgres Pro
Downloads
Home   >   mailing lists

Latin1 characters in sql scripts - Mailing list pgsql-novice

From Rick Szeto
Subject Latin1 characters in sql scripts
Date
Msg-id sdb928da.072@mail.tor.csi.ca
Whole thread Raw
List pgsql-novice
Tree view 
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:

Previous
From: Tom Lane
Date:
Subject: Re: function problems.
Next
From: "Nicolas ..."
Date:
Subject: Parameters for views based on other views