Inserting Unicode into Postgre

From: "Firestar" <theebh(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Inserting Unicode into Postgre
Date: 2001-04-17 03:27:28
Message-ID: 9bgd0t$up2$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Dunford 2001-04-17 06:07:11 Re: bpchar type
Previous Message Hiroshi Inoue 2001-04-16 23:35:54 Re: Driver ODBC postdrv.exe fails on 7.1