db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Oracles NVARCHAR2 equivalent in Derby ?
Date Wed, 05 Jan 2005 17:56:45 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

it is not clear from your message what you want from the datatype, but
if it is simply to be able to store and retrieve chinese characters then
you can use the standard character types char, varchar, long varchar
depending on the length requirements of the column.

One of the benefits of implementing derby in java is that it takes
advantage of java's unicode aproach to strings/characters.  Internally
all strings either are accessed as the java String datatype or the java
char[] datatype, which both handle unicode characters.  The jdbc
interfaces similarly input/output either String or char[], which should
handle the chinese character sets.

Applications need not worry about it, but at the lowest level the
storage system uses a slightly modified UTF8 encoding in order
to compress those strings which are mostly ASCII into 1 byte per character.

Bernd Ruehlicke wrote:
| Hi there,
|
| to support UNICODE variable-length - as in storing chinese character set
| Oracle has the NVARCHAR2 type.
|
| Would that be the "LONG VARCHAR" in Derby ?
|
| Thanx
| B-)
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFB3CpbEpeslyHqPs0RArNEAJ9It1xW2jHcTQ5/SThVjJtCmsR3JwCgqcAz
TcqHvBeVMQlECigONAUcwkQ=
=ZgNu
-----END PGP SIGNATURE-----

Mime
View raw message