Uploaded image for project: 'Spring Roo'
  1. Spring Roo
  2. ROO-1684

The UTF8 (german and cyrillic) data is not correctly written to the database

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Complete
    • 1.1.0.RELEASE
    • 1.1.1.RELEASE
    • WEB MVC
    • None
    • Windows XP, tomcat

    Description

      The utf8 characters are not correctly written to database.

      a) german special characters (ö,ä,ß,ü)
      b) cyrillic characters (щвды...)

      See
      http://forum.springsource.org/showthread.php?p=327431#post327431
      and
      https://jira.springsource.org/browse/ROO-89?focusedCommentId=60102#action_60102

      I did some tests already, it didnt help:

      1. Set the CharacterEncodingFilter filter in web.xml to first place
      2. Set <property name="hibernate.connection.charSet" value="UTF-8" /> in persistence xml
      3. I updated the DB manually with a correct UTF8 data (copied from hsqldb from same application but in grails) and is showed correctly, so the utf8 data is correcly read\displayed from database.

      I have same application in grails. Same db (hsqldb), db settings, db version.

      Here the sample of data in:

      Grails:
      Entered value "Привет München",
      value in db "INSERT INTO GUETER_EINHEIT VALUES(17,0,'\u041f\u0440\u0438\u0432\u0435\u0442 M\u00fcnchen')"

      Roo:
      Entered value "привет münchen",
      value in the db "INSERT INTO GUETER_EINHEIT VALUES(2,'\u00d0\u009f\u00d1\u0080\u00d0\u00b8\u00d0\u00b2\ u00d0\u00b5\u00d1\u0082 m\u00c3\u00bcnchen',0)"

      Very strange, I see in Roo for one special character two unicode characters and the generated unicode of grails and roo is different

      Attachments

        Issue Links

          Activity

            People

              sschmidt Stefan Schmidt
              eugeis Eugen Eisler
              Archiver:
              tmarshall Trevor Marshall

              Dates

                Created:
                Updated:
                Resolved:
                Archived: