| From: | Bruce Badger <bruce_badger(at)BadgerSE(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Multibyte characters over the frontend/backend protocol |
| Date: | 2002-12-04 01:54:29 |
| Message-ID: | 3DED6055.8090702@BadgerSE.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-12-05 00:00:58 | Re: Multibyte characters over the frontend/backend |
| Previous Message | prashanth | 2002-12-03 23:40:47 | Problem with Python interface with PostgreSQL 7.3 |