RE: How to read/write multibyte to database

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: jklcom(at)mindspring(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: How to read/write multibyte to database
Date: 2001-03-12 01:10:53
Message-ID: 20010312101053S.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sra(dot)co(dot)jp]
> Sent: Saturday, March 10, 2001 8:39 AM
> To: jklcom(at)mindspring(dot)com
> Cc: pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan McGrath 2001-03-12 01:34:43 Re: Re: Anyone can create tables!
Previous Message Gavin Sherry 2001-03-12 00:56:19 Re: Money...