Thread: HELP HELP HELP !!!!

HELP HELP HELP !!!!

From
"sharma;G.S."
Date:
can any body tell me how can i insert a french character in a table of postgre.
 
i have made a data base by setting  UNICODE encoding.
 
create table a (b char(255));
I unable to set any french character in the table.....
what should i do...
any help will be highly appericiated..
Thanx in Advance..
 
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, coping, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable.

Re: HELP HELP HELP !!!!

From
John DeSoi
Date:
On Mar 22, 2005, at 5:52 AM, sharma;G.S. wrote:

> can any body tell me how can i insert a french character in a table of
> postgre.
>  
> i have made a data base by setting  UNICODE encoding.
>  
> create table a (b char(255));
> I unable to set any french character in the table.....
> what should i do...
> any help will be highly appericiated..
> Thanx in Advance..


It should work just by ensuring that you have the client side encoding
set correctly. In psql, you can use something like:

\encoding UNICODE

If you still can't find a solution, create a simple example in psql and
post your output so we can see the problem.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL