RE: How to read/write multibyte to database - Mailing list pgsql-general

From Tatsuo Ishii
Subject RE: How to read/write multibyte to database
Date
Msg-id 20010312101053S.t-ishii@sra.co.jp
Whole thread Raw
In response to RE: How to read/write multibyte to database  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-general
> Ok, if I change to use EUC_TW or UTF-8 encoding, do I need to make any
> changes to my code?

No.

> What do I need to do differently on the web content?

Nothing, I guess.

> Thanks
>
> -----Original Message-----
> From: Tatsuo Ishii [mailto:t-ishii@sra.co.jp]
> Sent: Saturday, March 10, 2001 8:39 AM
> To: jklcom@mindspring.com
> Cc: pgsql-general@postgresql.org
> Subject: RE: [GENERAL] How to read/write multibyte to database
>
>
> > I'm using BIG5
>
> Then you lose. Because BIG5 containts byte patterns conflicting with
> ASCII special charcters (like '\'), I guess your code:
>
>     for(i=0; *queryString; i++)
>     {
>       splitword(items.Item, queryString, '&');
>       unescape_url(items.Item);
>       splitword(items.name, items.Item, '=');
>
>       if(!strcmp(items.name, "Name"))
>       {
>         strcpy(name, items.Item);
>       }
>       else if(!strcmp(items.name, "Address"))
>       {
>         strcpy(address, items.Item);
>       }
>
> won't work. Change your program to treat BIG5 carefully.  Or you
> probably better to use EUC_TW or UTF-8 to write your web contents.
> --
> Tatsuo Ishii

pgsql-general by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Money...
Next
From: Tom Lane
Date:
Subject: Re: Anyone can create tables!