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."