From ghanshyam@newgen.co.in Tue Mar 22 11:13:24 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87071569B9 for ; Tue, 22 Mar 2005 11:13:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75297-10 for ; Tue, 22 Mar 2005 11:13:23 +0000 (GMT) Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by svr1.postgresql.org (Postfix) with SMTP id C30E5569BC for ; Tue, 22 Mar 2005 11:13:21 +0000 (GMT) Received: (qmail 31675 invoked by uid 504); 22 Mar 2005 11:18:26 -0000 Received: from ghanshyam@newgen.co.in by mx.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:0(202.140.41.205):. Processed in 2.571824 secs); 22 Mar 2005 11:18:26 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 22 Mar 2005 11:18:23 -0000 Received: (qmail 21507 invoked by uid 504); 22 Mar 2005 11:19:17 -0000 Received: from ghanshyam@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.190):. Processed in 2.141976 secs); 22 Mar 2005 11:19:17 -0000 Received: from unknown (HELO ng3024) (192.168.5.190) by 192.168.5.243 with SMTP; 22 Mar 2005 11:19:14 -0000 Message-ID: <06c201c52ecd$4e0c4ed0$be05a8c0@ng3024> From: "sharma;G.S." To: Subject: HELP HELP HELP !!!! Date: Tue, 22 Mar 2005 16:22:56 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_06BF_01C52EFB.67A47FB0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.146 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, HTML_TEXT_AFTER_BODY, HTML_TEXT_AFTER_HTML, PLING_PLING, RCVD_BY_IP, SUBJ_ALL_CAPS X-Spam-Level: *** X-Archive-Number: 200503/340 X-Sequence-Number: 16838 This is a multi-part message in MIME format. ------=_NextPart_000_06BF_01C52EFB.67A47FB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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.. ------=_NextPart_000_06BF_01C52EFB.67A47FB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
can any body tell me how can i insert a = french=20 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=20 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. ------=_NextPart_000_06BF_01C52EFB.67A47FB0-- From desoi@pgedit.com Tue Mar 22 12:42:40 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B4EA52A62 for ; Tue, 22 Mar 2005 12:42:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14925-02 for ; Tue, 22 Mar 2005 12:42:30 +0000 (GMT) Received: from a2s1.a2webhosting.com (host-180.a2webhosting.com [69.39.89.180]) by svr1.postgresql.org (Postfix) with ESMTP id 5A16656677 for ; Tue, 22 Mar 2005 12:42:29 +0000 (GMT) Received: from user-1120jls.dsl.mindspring.com ([66.32.78.188] helo=[192.168.1.10]) by a2s1.a2webhosting.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.44) id 1DDiiO-0005fP-3K; Tue, 22 Mar 2005 07:42:32 -0500 In-Reply-To: <06c201c52ecd$4e0c4ed0$be05a8c0@ng3024> References: <06c201c52ecd$4e0c4ed0$be05a8c0@ng3024> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: Content-Transfer-Encoding: quoted-printable Cc: From: John DeSoi Subject: Re: HELP HELP HELP !!!! Date: Tue, 22 Mar 2005 07:42:16 -0500 To: "sharma;G.S." X-Mailer: Apple Mail (2.619) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s1.a2webhosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.224 tagged_above=0 required=5 tests=AWL, PLING_PLING X-Spam-Level: X-Archive-Number: 200503/341 X-Sequence-Number: 16839 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=A0a table = of=20 > postgre. > =A0 > i have made a data base=A0by setting =A0UNICODE encoding. > =A0 > 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=20= 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=20= post your output so we can see the problem. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL