db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: Binding a char to PreparedStatement
Date Fri, 22 Jul 2005 08:04:12 GMT
Craig Russell wrote:

> Hi Erik,
> 
> On Jul 21, 2005, at 2:10 AM, erik@jpox.org <mailto:erik@jpox.org> wrote:
> 

>> CHAR(1) will not allow Unicode storage, you need either to use NCHAR(1),
>> CHAR(4) or another type that allows you to store 2 bytes.
> 
> 
> Correct. The point is what should be the default.

Well, implementation defined really. Derby defines CHAR(1) as storage
for one *character*, not one byte, character is really the intent of the
SQL spec. Derby always uses Unicode as the character set, so CHAR(1) can
store any Unicode character from Java.

Dan.



Mime
View raw message