uPortal
  1. uPortal
  2. UP-3488

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

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: 4.0.5
    • Fix Version/s: 4.1.0
    • 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

      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.

        Activity

        Hide
        Vincent Bonamy added a comment -

        Pull Request on github :
        We suggest yous use @type(type = org.hibernate.type.TextType) for @lob type.
        https://github.com/Jasig/uPortal/pull/47

        With that, we no longer use pg_catalog.pg_largeobject for preferences (like before the uPortal4 version).

        The problem of this modification here is : for the current portlet preferences saved on postgresql database, you have to make a migration ... like an export/import process.

        Show
        Vincent Bonamy added a comment - Pull Request on github : We suggest yous use @type(type = org.hibernate.type.TextType) for @lob type. https://github.com/Jasig/uPortal/pull/47 With that, we no longer use pg_catalog.pg_largeobject for preferences (like before the uPortal4 version). The problem of this modification here is : for the current portlet preferences saved on postgresql database, you have to make a migration ... like an export/import process.

          People

          • Assignee:
            Unassigned
            Reporter:
            Vincent Bonamy
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: