pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Miguel Higuera <miguelstratoss@gmail.com>
To: Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
To: pgsql-admin@postgresql.org
Subject: Re: FW: Libpq - multibyte character support
Date: Wed, 7 Sep 2005 00:03:49 -0500
Message-ID: <f11b7a0d050906220353cd6f7f@mail.gmail.com> (raw)
In-Reply-To: <77ED2BF75D59D1439F90412CC5B1097423F87B47@ie10-sahara.hiso.honeywell.com>
References: <77ED2BF75D59D1439F90412CC5B1097423F87B47@ie10-sahara.hiso.honeywell.com>

CREATE DATABASE name ENCODING = WIN1256

THIS MAY BE THE SOLUTION
ALSO YOU CAN PROBE WITH :
ALT, LATIN1 TO LATIN9, EUC_CN, EUC_JP,EUCCREATE DATABASE name ENCODING = 
WIN1256

THIS MAY BE THE SOLUTION
ALSO YOU CAN PROBE WITH :
ALT, LATIN1 TO LATIN9, EUC_CN, EUC_JP,EUC_KR......................

I WAIT THIS BE USEFULL
_KR......................

I WAIT THIS BE USEFULL


2005/9/6, Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>:
> 
> 
> 
> 
> 
>    Hi all, 
>       
>       My question is does PgSQL libpq functions support multibyte 
>       characters...if not then is there a way to provide multibyte data to 
>       Postgres using libpq functions. The other question is does Postgres support 
>       Chinese characters....if I insert chinese characters into a table, when I 
>       read, will I get the same chinese characters. Please help me out in this 
>       regard.
>       
>       I have created a database with UNICODE support which has a 
>       table GSNames(Gsname varchar(40), status int, errorcode int) 
>       I tried to insert into this table from a simple C program 
>       using libpq functions....but it gives error as libpq does not support wchar 
>       datatypes. Here is the code - 
>       
>       int main() 
>       { 
>       // wchar_t szQuery[255]; 
>       char szQuery[255]; 
>       
>       PGconn *DBCon; 
>       PGresult *DBResult; 
>       
>       //Connect to the database with default settings 
>       DBCon = PQsetdbLogin(NULL, NULL, NULL, NULL, "test1", 
>       "postgres", ""); //test1 is database created with UNICODE encoding
>       
>       //check if there is any error in connecting to the database 
>       if(PQstatus(DBCon) == CONNECTION_BAD) 
>       { 
>       fprintf(stderr,"\nGetAttributeInfo(): Connection to database 
>       failed."); 
>       fprintf(stderr,"\nGetAttributeInfo(): %s", 
>       PQerrorMessage(DBCon)); 
>       return ERROR_DB_CON; 
>       } 
>       else 
>       { 
>       fprintf(stderr,"\nGetAttributeInfo(): Connection to database 
>       successful."); 
>       } 
>       
>       //form the DELETE command as character buffer. 
>       //swprintf(szQuery,500,L"INSERT INTO gsnames 
>       values('×¢²á',2,2)"); 
>       sprintf(szQuery,"INSERT INTO gsnames values('×¢²á',2,2)"); 
>       
>       //execute the command. 
>       DBResult = PQexec(DBCon, (char *)szQuery); 
>       
>       //check for any errors in executing the query. 
>       if(PQresultStatus(DBResult) != PGRES_COMMAND_OK) 
>       { 
>       fprintf(stderr,"\nGetAttributeInfo(): %s", 
>       PQresultErrorMessage(DBResult)); 
>       PQclear(DBResult); 
>       PQfinish(DBCon); 
>       return ERROR_DB_EXEC; 
>       } 
>       else 
>       { 
>       fprintf(stderr,"\nDBInsertPointAttribute(): Insertion 
>       successful. No. of rows affected = %d.", PQntuples(DBResult));
>       
>       } 
>       
>       PQclear(DBResult); 
>       PQfinish(DBCon); 
>       
>       return 0; 
>       } 
>       
>       The problem is I am not able to pass multibyte characters to 
>       postgres. Please help.....Thanks in advance. 
>       
>       Between I am using Postgres version 7.4.3. While installing 
>       Pgsql, I dnt specify any encoding or multi byte character support for 
>       initdb.
>       
>       Regs, 
>       Pradeep 
>       
>       
>

view thread (3+ messages)  latest in thread

Message-ID: <f11b7a0d050906220353cd6f7f@mail.gmail.com>
Permalink:  ../f11b7a0d050906220353cd6f7f@mail.gmail.com/
Also on:    postgresql.org/message-id/f11b7a0d050906220353cd6f7f@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: miguelstratoss@gmail.com, Pradeepkumar.Pyatalo@honeywell.com
  Subject: Re: FW: Libpq - multibyte character support
  In-Reply-To: <f11b7a0d050906220353cd6f7f@mail.gmail.com>
  References: <77ED2BF75D59D1439F90412CC5B1097423F87B47@ie10-sahara.hiso.honeywell.com> <f11b7a0d050906220353cd6f7f@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox