I insalled Postgres 8 in Windows XP with default settings I
xreated database with encoding unicode.
Unicode is not currently supported when the server runs on Win32, see
#2.6. You'll need to
pick a different encoding if you need locale-aware sorting.
This is something we hope to have fixed in 8.1.
//Magnus
(end of broadcast)
TIP 5: don't forget to increase your free space map settings

Unicode is not currently supported when the server runs on Win32, see
#2.6. You'll need to
pick a different encoding if you need locale-aware sorting.

I need to upsize tables from other dbms. This dbms does not support unicode.
I have tables which contain estonian language characters in one column
(using windows-1257 encoding) and russian langugage characters in other
column (using windows-1251 encoding) as single byte characters.
I use Postgres through DBC.

I tried the following encodings for upsize this table with the following
results:

SQL_ASCII - non ascii characters are converted to question marks. This is
problably by DBC driver since pgAdmin shows them.

LATIN1, LATIN4 - some characters cause error if I try to upsize my data to
Postgres (I use odbc for upsize).

If unicode is not working, I need fully transparent access through DBC: all
bytes in range 32 255 must be stored in unmodified form in CHARACTER and
TEXT fields and returned in unmodified form to my DBC client.
This does not allow UPPER() function to work but at least sorting is
somewhat meaningful (when sorted by unsigned binary values.)

Unfortunately it seems that DBC driver replaces some charactes to question
marks in case on SQL_ASCII .
So I need SQL_UNSIGNED_BINARY or SQL_TRANSPARENT encoding.
I tried to use binary data types insted of char and text types but pgADMIN
show them as octal strings.
I have no idea, meybe it is possible configure or modify odbc driver. I
looked into odbc drivers sources but havent found place which converts
chars>0x80 to question marks.

Any idea ?

When fixed unicode version (8.1?) will be available ?

Andrus.

(end of broadcast)
TIP 2: Don't 'kill -9' the postmaster