After installing the Sitefinity application and connecting to an oracle database, the table creation process is adding quotation marks around the table and columns. Is there a way to disable this feature? Internally the quotation marks have to be included in any query.
Doesn't work - no quotation marks:
select content_id from SITEFINITY.sf_blg_psts_pblshd_trnslations;
Error starting at line : 8 in command -
select content_id from SITEFINITY.sf_blg_psts_pblshd_trnslations
Error at Command Line : 8 Column : 35
Error report -
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
Works - with quotation marks:
select "content_id" from SITEFINITY."sf_blg_psts_pblshd_trnslations";