Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
5.0
-
ezp legacy mode with Oracle db
Description
Regarding Oracle, the installed DB schema states that the Content Object Name field is set to VARCHAR(255). This statement means that the maximum lenght of the field can be 255 BYTES, while the intention according to the documentation is 255 Characters.
The correct definition would be VARCHAR(255 CHAR), which would adjust the allowed space to the selected character set according to: http://ss64.com/ora/syntax-datatypes.html
"Oracle9i and above allow Varchar2 columns to be defined as a number of bytes VARCHAR2(50 BYTE) or a number of characters VARCHAR2(50 CHAR), the latter is useful if the database is ever converted to run a double-byte character set (such as Japanese), you won't have to edit the column sizes. The default measure, normally BYTE, is set with nls_length_semantics."
Attachments
Issue Links
- discovered while testing
-
EZP-21398 Documentation Update: missing documentation for ContentObjectNameLimit
- Closed
-
EZP-21410 object name limit does not support multibyte charset
- Closed
- relates to
-
EZP-21585 eZOracle: ORA-12899: when creating content in japanese with long name (using multi-byte chars)
- Closed