How to read/write multibyte to database

Поиск
Список
Период
Сортировка
От Jeff
Тема How to read/write multibyte to database
Дата
Msg-id 989nsa$l4o$1@news.tht.net
обсуждение исходный текст
Список pgsql-general
Hi,

I have a form that contains data with Chinese characters.  When it's
submited through http request, how can I write it to the database?

Currently I'm getting garbage when retrieve the records.

Here's code snippets:

  contentTypeFromPost = getenv("CONTENT_TYPE");
  contentTypeLength = getenv("CONTENT_LENGTH");
  icontentLength = atoi(contentTypeLength);

   if((queryString = malloc(icontentLength + 1)) == NULL)
   {
      postMessage("Cannot allocate memory", 0);
      return(0);
   }
  ...
    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);
      }

   ...

       sprintf(query_string, "INSERT INTO info values('%s', '%s')", name,
address);
       res = PQexec(conn, query_string);

      name & address are in Chinese.
      Do I have to do any conversion before writing to the database?

-Jeff



В списке pgsql-general по дате отправления:

Предыдущее
От: "Jeff"
Дата:
Сообщение: How to read/write multibyte to database
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: How to read/write multibyte to database