[EMPIREDB-122] Chinese characters being inserted as ??? on SqlServer (non-prepared statement)

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: empire-db-2.2.0-incubating
• Fix Version/s: empire-db-2.3.0
• Component/s: Core
• Labels: charset encoding
• Assignee: Rainer Döbele
• Reporter: Francis De Brabandere
• Created: 09/Nov/11 19:44
• Updated: 04/Feb/13 14:14
• Resolved: 13/Nov/11 18:48

Description

Reported by Ben Ng

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