This content has been marked as final. Show 2 replies
Be wary of using character codes outside the Western European "simple" alphanumeric [A-Z0-9] for object names, i.e. columns, table names, function and procedure names, and so on.
First reason, there is a 30 character limit for most object names, and characters that have to be spelled out with unicode characters take more space, i.e.:
Although the varchar string for that column name looks like 25 characters, it needs room for 29 to store the e<acute> character. And could also depend on the client settings. Using case sensitive names is not a best practice, its better to avoid specifying objects with the double quotes.
select dump( 'Détermination Planimétriq' ) from dual; DUMP('D?TERMINATIONPLANIM?TRIQ') Typ=96 Len=29: 68,239,[ ... ]