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:[email protected]] > to: [email protected] > 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 <[email protected]> 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 <[email protected]> > 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:[email protected]] > >> to: [email protected] > >> 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.
