Character Set UTF8 and libpq

From: "Nagle, Gail A \(US SSA\)" <gail(dot)nagle(at)baesystems(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Character Set UTF8 and libpq
Date: 2009-01-06 00:32:29
Message-ID: 7b4dai$cgs1q@dmzms99901.na.baesystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Suppose a database is created to use UTF8 encoding using the following
command:

createdb -E UTF8 customers

Further suppose that a table is created consisting of two columns,
cust_name of type text, and cust_number of type integer.

Later, the customers database is accessed programmatically by the
PQexec() or PqexecParams() methods, each of which take a const char
*command parameter. In the program the value of the char* command
parameter is built up sequentially by appending bytes to an array of
unsigned char. For example, the value could be created by concatenating
"INSERT INTO mytable VALUES(" with a unicode valued array for the
cust_name column and a simple ascii string for the cust_number.

My question is does the entire string, i.e. "INSERT INTO mytable
VALUES(" and the integer value need to be UTF8 encoded or can these
parts be in plain ascii text?

Thank you,
Gail

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-01-06 02:12:31 Re: Character Set UTF8 and libpq
Previous Message ries van Twisk 2009-01-05 23:35:58 Re: VARCHAR AND TEXT DATA TYPES