I think I can actually answer some of these questions :) On 9/6/07, Ken Frank <[EMAIL PROTECTED]> 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 > > > > >