Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-21585

eZOracle: ORA-12899: when creating content in japanese with long name (using multi-byte chars)

    Details

      Description

      Content publishing fails (with fatal error), when the data to store as the object name exceeds the database limit size for the column.

      Error (12899): ORA-12899: value too large for column "EZCONTENTOBJECT_ATTRIBUTE"."SORT_KEY_STRING" (actual: 464, maximum: 255)

      Steps to reproduce

      . edit article class so that the title can hold up to 512 characters
      . create and publish an article with the following title:

      私は簡単にパブリッシュの記事で使用することができるようなもの、何でも、記述する必要が、それはそう、私はただ何を書き留めて、何を参照してくださいますね、あなたが実際にTIに考えている心の中で何かが出てくるのが難しいのようなものだ登場。ポイントは、私が百五文字が必要だということです。これで十分です。くそー、もっと2

        Issue Links

          Activity

          Hide
          Yannick Roger (Inactive) added a comment -

          PRs :
          on legacy: https://github.com/ezsystems/ezpublish-legacy/pull/811
          on ezoracle: https://github.com/ezsystems/ezoracle/pull/18

          You need to have both patches to fix the issue. But these patches don't break anything if only one of them is applied.

          Show
          Yannick Roger (Inactive) added a comment - PRs : on legacy: https://github.com/ezsystems/ezpublish-legacy/pull/811 on ezoracle: https://github.com/ezsystems/ezoracle/pull/18 You need to have both patches to fix the issue. But these patches don't break anything if only one of them is applied.
          Show
          Yannick Roger (Inactive) added a comment - Fixed in master : https://github.com/ezsystems/ezpublish-legacy/commit/c94dd421b711fb78431697ea213e40347d516641 https://github.com/ezsystems/ezoracle/commit/77343529dc98557c770015bad4e45ae88faea6f8
          Show
          Ricardo Correia (Inactive) added a comment - The current Oracle field size limitation in bytes has been documented in: http://doc.ez.no/Extensions/eZ-Publish-extensions/eZ-Publish-Extension-for-Oracle-R-database/5.0/Installation/Oracle-Specific-Notes http://doc.ez.no/Extensions/eZ-Publish-extensions/eZ-Publish-Extension-for-Oracle-R-database/2.0/Oracle-specific-notes http://doc.ez.no/Extensions/eZ-Publish-extensions/eZ-Publish-Extension-for-Oracle-R-database/1.8/Oracle-specific-notes http://doc.ez.no/Extensions/eZ-Publish-extensions/eZ-Publish-Extension-for-Oracle-R-database/1.5/Oracle-specific-notes http://doc.ez.no/Extensions/eZ-Publish-extensions/eZ-Publish-Extension-for-Oracle-R-database/1.4/Oracle-specific-notes

            People

            • Assignee:
              Unassigned
              Reporter:
              Joaquim Cavalleri (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 days, 7 hours
                4d 7h