Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Guillaume Laforge
On 29/07/05, Thomas Dudziak <[EMAIL PROTECTED]> wrote: > Ok, in that case I think it is better if I simply create a FAQ entry. Right, a FAQ entry is probably more appropriate. Thanks everybody for your help. -- Guillaume Laforge http://glaforge.free.fr/weblog/?catid=2 -

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Thomas Dudziak
On 7/29/05, Guillaume Laforge <[EMAIL PROTECTED]> wrote: > Hi Tom! > > Well, yes and no. Should I create an issue or not? > Since the problem can be considered a database configuration issue? > Simply setting the NLS_CHARACTERSET to UTF8 makes the JDBC driver and > the Oracle instance to talk toge

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Guillaume Laforge
Hi Tom! On 28/07/05, Thomas Dudziak <[EMAIL PROTECTED]> wrote: > Bobby is right, Oracle does not seem to be able to handle NCHAR > directly in the JDBC driver; you are required to use the > Oracle-specific extension. > This might be a useful enhancement in the Oracle platform ... > Guillaume, coul

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-29 Thread Guillaume Laforge
Hi, On 28/07/05, Bobby Lawrence <[EMAIL PROTECTED]> wrote: > I don't think OJB has any connection-specific configuration, but you can > try this code on your insert: > > ClassDescriptor classDescriptor = broker.getClassDescriptor(YourClass.class); > PreparedStatement statementInsert = > broker.s

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Thomas Dudziak
Bobby is right, Oracle does not seem to be able to handle NCHAR directly in the JDBC driver; you are required to use the Oracle-specific extension. This might be a useful enhancement in the Oracle platform ... Guillaume, could you raise a JIRA issue for this ? Tom

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Bobby Lawrence
Guillaume - I don't think OJB has any connection-specific configuration, but you can try this code on your insert: ClassDescriptor classDescriptor = broker.getClassDescriptor(YourClass.class); PreparedStatement statementInsert = broker.serviceStatementManager().getInsertStatement(classDescript

Re: Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Guillaume Laforge
I forgot to mention that I'm using Oracle9i's thin driver and its ojdbc14.jar. With a version 9.2.0.4 of Oracle9i. On 28/07/05, Guillaume Laforge <[EMAIL PROTECTED]> wrote: > Hello, > > On my current project, I'm using Oracle9i and OJB. The version of OJB > is rather old: that's 1.0.0, but I may

Stroring internationalized strings in Oracle9i with OJB

2005-07-28 Thread Guillaume Laforge
Hello, On my current project, I'm using Oracle9i and OJB. The version of OJB is rather old: that's 1.0.0, but I may and will certainly upgrade to 1.0.3 if that's needed. I'm storing sentences in 40 different languages (English, French, Japanese, Chinese, etc...). All the columns of my tables whi