The following bug has been logged online:

Bug reference: 1315
Logged by: CN

Email address: cnliou9 (AT) fastmail (DOT) fm

PostgreSQL version: 8.0 Beta

Operating system: Linux

Description: unconvertible BIG5 character 0xf9d8

Details:

Sorry for cross posting here after 2 days' silence regarding this issue in
general list!

My 8.0beta2 database was initialized with option "-E UNICODE". Psql sets
client encoding to Big5:

database1=# \encoding big5

I get this error when inserting Big5 character 0xf9d8:

WARNING: ignoring unconvertible BIG5 character 0xf9d8


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

The error message says all. The BIG5 char 0xf9d8 is not considered
legal by PostgreSQL. More techinicaly, the UNICODE --> BIG5 conversion
map (src/backend/utils/mb/Unicode/big5_to_utf8.map) does not have an
entry for 0xf9d8. There are two possible solutions:

1) If there is any "standard confirmance" map including an entry for
0xf9d8, we are happy to replace it with the one we have.

2) you could create your own conversin map including 0xf9d8 using
CREATE CONVERSION command. See docs for more details.
--
Tatsuo Ishii

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly