incubator-empire-db-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francis De Brabandere <franci...@gmail.com>
Subject Re: Inserting Chinese character record to DB
Date Mon, 07 Nov 2011 10:25:56 GMT
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