French Characters - Mailing list pgsql-general

From Al-Karim Bhamani (LCL)
Subject French Characters
Date
Msg-id 83606C47747D1D41834A1E3A8226CD690E2094@lclmxhq01.ngco.com
Whole thread Raw
List pgsql-general

I created a database using UNICODE Characterset.

 

Created a table

CREATE TABLE a (

  a char(30)

);

 

Tried to insert a row through PG_ADMIN

insert into a values('qualité')

 

This resulted in the following error

 

Number: -2147467259

Description: ERORR: Invalid UNICODE character sequence found (0xe90000)

 

 

I believe It's because of the French character "é" .

 

We need to insert French characters in the database.

 

The DATABASE is UNICODE

Is there anything which I am missing.

 

Please Advice

 

pgsql-general by date:

Previous
From: Damien
Date:
Subject: speed w/ OFFSET/LIMIT
Next
From: Jean-Christian Imbeault
Date:
Subject: Re: newbie sql question...