From: David Warnock <david@sundayta.co.uk>
To: t-ishii@sra.co.jp
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] JDBC and character sets
Date: Tue, 22 Jun 1999 14:54:11 +0100
Message-ID: <376F9583.BFB85129@sundayta.co.uk> (raw)
References: <199906221207.VAA09978@srapc451.sra.co.jp>
Tatsuo,
Many thanks for your reply.
I think I saw from the list of developers that you wrote a lot of the
multiu-byte code. Is that correct? If so my grateful thanks.
Are there any limitations or gotchas about using unicode everywhere?
Specifically
1. Column length. Is this measured in unicode characters or do I need to
increase the length of Varchars? ie is a varchar(10) certain to hold 10
unicode characters?
2. Indexing. What sort order will I get from an index or an order by for
unicode characters. Can this be customised. Generally I try to do any
really important sorting in Java where I can use the correct sort order
for the locale.
3. Upper/lowercase. I have been using separate columns for uppercase
versions of names etc again so that the case changes can be done by the
client which will know the correct rules for the locale where the data
is entered. What do upper/lower case functions in Postgresql do with
unicode?
4. Are there any limitations on what I use to write triggers? Can all
the different ways work reliably with unicode?
Many many thanks.
Dave
--
David Warnock
Sundayta Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: david@sundayta.co.uk, t-ishii@sra.co.jp
Subject: Re: [INTERFACES] JDBC and character sets
In-Reply-To: <376F9583.BFB85129@sundayta.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox