Re: Derby and character set encodings

[Ken Frank <Ke...@Sun.COM>]

the one remaining question, for the folks at derby-user (and adding 
derby-dev) is the first one:

1.  when one creates a new derby database,
is the database created with a certain encoding that will be used ?

or is there an argument given to create command that can indicate the encoding to be used ?

And if so, is that encoding the default encoding of the locale I am in when I run
the create database command or is it utf-8 always ?
(for example, for one of the Japanese locales of Solaris, the encoding of it
is euc-jp)

or could it be that of the encoding of the locale the actual dbase server
is started in ?  (which might be java's view of the users locale/encoding
which would be I think the same as the OS locale user is in)

that is, user might start the db server in some separate locale from where they start netbeans.

Thanks - Ken
===========================================================================




David Van Couvering wrote:
> I think I can actually answer some of these questions :)
>
> On 9/6/07, Ken Frank <Ke...@sun.com> wrote:
>   
>> Thanks David for sending this.
>>
>> Let me note a few questions:
>>
>> 1.  when one creates a new database,
>> is the database created with a certain encoding that will be used ?
>>
>> And if so, is that encoding that of the locale I am in when I run
>> the create database commands or is it utf-8 always ?
>> (for example, for one of the Japanese locales of Solaris, the encoding of it
>> is euc-jp)
>>
>> or could it be that of the encoding of the locale the actual dbase server
>> is started in ?  (which might be java's view of the users locale/encoding
>> which would be I think the same as the OS locale user is in)
>>
>> I saw this from derby docs:
>> "To support users in many different languages, Derby's SQL parser
>> understands all Unicode characters and allows any Unicode character or
>> number to be used in an identifier."
>>
>> but I don't know if it means that there is no concept of an encoding
>> for a database itself or not.
>>
>> I think with Oracle for example, there is an argument to create database
>> that lets one specify the encoding of it.
>>
>>     
>
> This question stumps me, I'll leave it to others...
>
>   
>> 2.  The locale the user is in when starting derby server -
>> what things are affected by that - ie encoding of dbase, messages to
>> user (if translated), time, date, etc ?
>> (vs user needing to set separate variables or properties)
>>
>>     
>
> I don't know what "encoding of the dbase" means, but the other display
> stuff: exception messages, time and date and money formats, etc., are
> all controlled by locale.
>
>   
>> 3.  I think its allowed for identifiers like database names,
>> table and column names, to have non ascii in them, if proper
>> quoting is used when referring to them  ?
>>
>>     
>
> Yes, that's right.
>
>   
>> Thanks - Ken
>>
>>
>> David Van Couvering wrote:
>>
>>     
>>> Hi, all.  I am getting some questions from Ken Frank NetBeans
>>> internationalization quality team about Java DB and character set
>>> encodings.  Rather than try and play go-between, I'm including him
>>> here so he can directly ask any follow-on questions.
>>>
>>> Ken would like to understand how Derby makes use of character
>>> encodings, and how it is affected by  various settings.  How does
>>> Derby handle things if the encoding is set to something different from
>>> our default of UTF-8?  Are we impacted, or do we rely on Java routines
>>> such as the Collator and Comparator class to handle this?
>>>
>>> Sorry if I'm talking out my ear, i18n is not one of my fortes.
>>>
>>> Thanks,
>>>
>>> David
>>>
>>>
>>>       

-- 
========================================
if your reply to this mail bounces,
and reply was sent to kenf@<somemachinename>,
then please reply to ken.frank@sun.com  instead
===========================================

Re: Derby and character set encodings

[Daniel John Debrunner <dj...@apache.org>]

Ken Frank wrote:
> the one remaining question, for the folks at derby-user (and adding 
> derby-dev) is the first one:
> 
> 1.  when one creates a new derby database,
> is the database created with a certain encoding that will be used ?

No. The database doesn't have an encoding.

Dan.