You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Rainer Döbele (Resolved JIRA)" <em...@incubator.apache.org> on 2011/11/13 19:49:51 UTC
[jira] [Resolved] (EMPIREDB-122) Chinese characters being inserted
as ??? on SqlServer (non-prepared statement)
[ https://issues.apache.org/jira/browse/EMPIREDB-122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rainer Döbele resolved EMPIREDB-122.
------------------------------------
Resolution: Fixed
added override to DBDatabaseDriverMSSQL:
Function getSQLTextString() will add a Unicode Prefix (N) depending on property useUnicodePrefix. Default is true.
> Chinese characters being inserted as ??? on SqlServer (non-prepared statement)
> ------------------------------------------------------------------------------
>
> Key: EMPIREDB-122
> URL: https://issues.apache.org/jira/browse/EMPIREDB-122
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.2.0-incubating
> Reporter: Francis De Brabandere
> Assignee: Rainer Döbele
> Priority: Critical
> Labels: charset, encoding
> Fix For: empire-db-2.2.1-incubating
>
>
> 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira