Message-ID: <3DED6055.8090702@BadgerSE.com>
Date: Wed, 04 Dec 2002 12:54:29 +1100
From: Bruce Badger <bruce_badger@BadgerSE.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Multibyte characters over the frontend/backend protocol
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

I am trying to add multi-byte character support to the Smalltalk 
PostgreSQL driver, and I would really apreciate a bit of help in 
inderstanding the form in which I need to send things to the backend.

I create a database using: "create database multibytetest with encoding 
= ''KOI8'';"

I can see that it has been created OK using "psql -l"; I see: " 
multibytetest | bbadger  | KOI8"

I create a table using: "create table test(string VARCHAR(3));"

Now, here's where I don't know what to do.  I want to insert into the 
new table using something like:
    "insert into test values ("xyz");"
... but where "xyz" is really the KOI8 charaters  0x0422 0x0423 and 0x0416

The question is, what bytes should be sent in the String data type of 
the Query message I send to the back end?

If I make the whole string multi-byte, I get a sytax error at or near "i".

Pointers to documentation or functions in existing code would be much 
apreciated.  Thanks.