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**** > >
