incubator-empire-db-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele <doeb...@esteam.de>
Subject re: Inserting Chinese character record to DB
Date Mon, 07 Nov 2011 14:25:23 GMT
Hi Francis,

I agree but we need a test case for this.
It may as well depend on the JDBC-Driver used - in fact I don't know.
Also my Chinese is a little rusted ;-)

Regards
Rainer

> from: Francis De Brabandere [mailto:francisdb@gmail.com]
> to: empire-db-user@incubator.apache.org
> re: Re: Inserting Chinese character record to DB
> 
> I think this still is something we should fix for non-prepared statements
> 
> On Mon, Nov 7, 2011 at 9:41 AM, Ben Ng <cnj125@gmail.com> wrote:
> > Hi Rainer,
> >
> > It seems that my problem have been solved when I enable prepared
> statement.
> > Thank you for your help.
> >
> > Regards,
> > Ben
> >
> > On Mon, Nov 7, 2011 at 4:19 PM, Rainer Döbele <doebele@esteam.de>
> wrote:
> >>
> >> Hi Ben,
> >>
> >>
> >>
> >> I don't know for sure but it may be a good idea to tell Empire-db to
> >> use prepared statements.
> >>
> >> Simply write:
> >>
> >> db.setPreparedStatementsEnabled(true);
> >>
> >> in your initialization code.
> >>
> >>
> >>
> >> Please let us know whether this works and tell us which DBMS and
> >> JDBC-Driver you are using.
> >>
> >> Regards
> >>
> >>
> >>
> >> Rainer
> >>
> >>
> >>
> >>
> >>
> >> from: Ben Ng [mailto:cnj125@gmail.com]
> >> to: empire-db-user@incubator.apache.org
> >> re: Re: Inserting Chinese character record to DB
> >>
> >>
> >>
> >> Hi Empire-DB team,
> >>
> >> I am trying to insert a record with Chinese character from my JSP page.
> >> The encoding is set to UTF-8 already and I am trying to insert the
> >> record by the code below where "remarks" is a string contain Chinese
> characters.
> >>
> >>
> >>
> >>
> >> DBRecord rec = new DBRecord();
> >> rec.create(db.REQUESTS);
> >> rec.setValue(db.REQUESTS.REMARKS, remarks); rec.update(conn);
> >>
> >> After inserting the record, the data of the field REMARKS become "???".
> >>
> >>
> >>
> >>
> >> I tried to use traditional method(PreparedStatement) to insert this
> >> record by using the same db and connection.
> >> The data can be inserted correctly.
> >> Is there any step I have missed in my code so it can support UTF-8?
> >>
> >>
> >>
> >>
> >> I really appreciate for what your team have done. Thanks a lot.
> >>
> >> Thanks & Regards,
> >> Ben
> >
> 
> 
> 
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.

Mime
View raw message