| From: | He Weiping <laser(at)zhengmai(dot)com(dot)cn> |
|---|---|
| To: | Firestar <theebh(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inserting Unicode into Postgre |
| Date: | 2001-04-17 08:26:26 |
| Message-ID: | 3ADBFE32.FE10D345@zhengmai.com.cn |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Firestar wrote:
> Hi,
>
> I'm currently using PostgreSQL 7.0 on Solaris. My Java program receives
> strings in Big5
> encoding and will store them in PostgreSQL (via JDBC). However, the inserted
> strings become
> multiple '?' (question marks) instead everytime i do a insert command. And
> when i retrieve them,
> via JDBC, the string becomes those question marks.
>
> Is the problem due to the Unicode encoding that Java String uses, or must i
> enable multibyte-support
> in my postgre installation? If i enable multibyte support, should i create
> my table with Unicode support,
> or Big5?
>
Upgrade to just released 7.1,
now postgres can do unicode conversion to you.
(thanks to Mr. Tatsuo Ishii)
I think you should enable both enable-multibyte & enable-unicode-conversion
switch.
when building postgresql.
regards
Laser
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fabrizio.ermini | 2001-04-17 08:37:21 | Re: [GENERAL] Non-english articles on the techdocs.postgresql.org website |
| Previous Message | Firestar | 2001-04-17 07:56:26 | Re: Inserting Unicode into Postgre |