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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])