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

> 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