Skip site navigation (1) Skip section navigation (2)

Re: How to store unicode?

From: t-ishii(at)sra(dot)co(dot)jp
To: meskes(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to store unicode?
Date: 2000-08-30 23:40:12
Message-ID: 20000831084012K.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
> I've just been asked how to store unicode text in a postgresql database. The
> problem as I understand it is that unicode strings may contain binary 0s
> which might break string handling. Since I never tried, I think it's better
> to ask here before answering that question. 

I guess you are talking about UCS encoding. There is another encoding
for Unicode, called UTF-8. It does not 0s, so you could use it with
PostgreSQL. Actually we have some unicode(utf-8) regression tests in
src/test/mb and they seem working.

> The application uses ecpg so it's not only a backend question.

I guess ecpg is ok as long as using UTF-8.
--
Tatsuo Ishii

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-08-31 03:23:27
Subject: Re: Silent deadlock possible in current sources
Previous:From: Michael MeskesDate: 2000-08-30 23:00:10
Subject: How to store unicode?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group