Unicode support

[Ninad Agate <na...@SERENA.com>]

Does Derby 10.1 support UTF-8 and UTF-16 encodings? I have not been able
to find this information in the reference docs.
Thanks.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

Re: Unicode support

["Bernt M. Johnsen" <Be...@Sun.COM>]

Ninad Agate wrote:
> Does Derby 10.1 support UTF-8 and UTF-16 encodings? I have not been able
> to find this information in the reference docs.
> Thanks.

Derby supports Unicode for CHAR,VARCHAR,CLOB etc. Data is stored in UTF-8 on
disk, and transferred between network client and server in UTF-8.

Currently you can't choose other encodings.

But as seen from your application, Java is Unicode and Derby is Unicode so any
Unicode character may be stored in the database, regardless of the encoding.

Note: Wrt db path names there is a bug:
https://issues.apache.org/jira/browse/DERBY-728

-- 
Bernt Marius Johnsen, Database Technology Group,
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

RE: Unicode support

["Thomas J. Taylor" <th...@itqa.miami.edu>]

We're using Derby 10.1.2.0 with UTF-8 by default. With MySQL, we had to
either set the default character set in my.ini to UTF-8, or set the database
or table character set to UTF-8. There was no such need for Derby.
 
I'm sure someone else can give you more specific details about UTF support
in Derby, if needed.
 
Thomas

  _____  

From: Ninad Agate [mailto:nagate@SERENA.com] 
Sent: Friday, September 22, 2006 3:43 PM
To: derby-user@db.apache.org
Subject: Unicode support


Does Derby 10.1 support UTF-8 and UTF-16 encodings? I have not been able to
find this information in the reference docs.
Thanks.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message.