Skip to content

Data Model Quoted Columns

đŸ’¡ TL;DR - use --quote for quotedn or accented column names

If your database was created with quoted column names, you must specify use the --quote option on ApiLogicServer create.

Quoted Column Names

You need to use the --quote option for databases declared like this: Note: ALS will alias the column name by removing non-roman8 accented chars.

create table "STRESS_IDENTITY_BY_DEFAULT" (  "id" int generated by default as identity (increment by 1 start with 1 nocache) ,"some_text" varchar(40));

OR

CREATE TABLE MyTable (SerieNĂºmero varchar(11) ...

 

ApiLogicServer create --quote

In such cases, include the --quote option:

ApiLogicServer create --project_name=oracle_stress --quote --db_url='oracle+oracledb://stress:tiger@localhost:1521/?service_name=ORCL'