#oracle
Why physical table name length when i using oracle for DB platform only 18 character? (and all entities with names longer than 18 characters will be truncated in the DB automaticly)
Is there a way to adjust the length?
Hi Sepriyadi,Oracle Db prior to version 12.2 limits length to 30 bytes which in UTF-8 character set means you can store lesser than 30 characters. Outsystems entities in sql server have a larger physical table name like OSUR_1XO_StudentGymRoomBooking so an outsystems entity name can only be 18 characters including the OSUR and hash and would be truncated to OSUR_1XO_StudentGymRoomBoo. Version 12.2 onwards increases this limit to 128 bytes.
Hi Aalhad,
Thanks for reply my question. But how to adjust length physical table name in outsystems? because currently only 18 character include OSUSR_<prefix> if i create table from Service Studio, but if i create table directly, I could do it up to 50 characters.