Uploaded image for project: 'uPortal'
  1. uPortal
  2. UP-3488

Preferences : encoding pb with postgresql - UTF-8 non ascii characters

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 4.1.2, 4.2.0, 4.2.1, 4.2.2, 4.3.0, 4.3.1
    • Fix Version/s: 4.0.16, 4.1.3, 4.2.0, 4.2.1, 4.3.0, 4.3.1, 5.1.2
    • Component/s: Preferences
    • Labels:
      None
    • Environment:
      uPortal 4.0.5
      Postgresql 8.4
      jdk1.6.0_24
      8.4-701.jdbc4 or/and 9.0-801.jdbc4
      Debian Squeeze
      uPortal 4.3.2
      psql (PostgreSQL) 9.5.4

      Description

      If we save portlet preferences with non ascii characters (french accents for example), these characters are not correct when we get them back.

      select data from pg_catalog.pg_largeobject where loid='1261770'
      gives us
      """
      _De nouveaux services/portlets peuvent \352tre ajout\351s \340 votre page en cliquant sur 'Personnaliser'.
      """

      This problem with JPA/Hibernate, @Lob annotation and Postgresql seems to be critical and a known issue ... :
      CF http://stackoverflow.com/questions/5043992/postgres-utf-8-clobs-with-jdbc and related resources.

      Thanks for help.

        Attachments

        Error rendering 'com.atlassian.jira.jira-view-issue-plugin:attachmentmodule'. Please contact your JIRA administrators.

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                vbonamy Vincent Bonamy
              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: