Inserting Unicode into Postgre - Mailing list pgsql-general

From Firestar
Subject Inserting Unicode into Postgre
Date
Msg-id 9bgd0t$up2$1@news.tht.net
Whole thread Raw
Responses Re: Inserting Unicode into Postgre
List pgsql-general
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?

Thanks in advance.

Firestar



pgsql-general by date:

Previous
From: Michael McDonnell
Date:
Subject: parse error at or near $1
Next
From: Calvin Dodge
Date:
Subject: Re: Driver ODBC postdrv.exe fails on 7.1