Uploaded image for project: 'Empire-DB'
  1. Empire-DB
  2. EMPIREDB-122

Chinese characters being inserted as ??? on SqlServer (non-prepared statement)

    XMLWordPrintableJSON

    Details

    • 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:

      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

        Attachments

          Activity

            People

            • Assignee:
              doebele Rainer Döbele
              Reporter:
              francisdb Francis De Brabandere
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: