Marcel Hoefs
Rank: #35349
37Views
4Comments
NLS_LENGTH_SEMANTICS setting
Question
Database

I would like to know where I can configure the NLS_LENGTH_SEMANTICS setting Outsystems 10 uses for external database connections? 

We have an Outsystems 10 environment that connects to an external Oracle database. I see different setting for NLS_LENGTH_SEMANTICS in database sessions and in Outsystems. I would like to use the same NLS settings in the database and Outsystems.

Thank you for your help!

0
0
on 2020-01-20
Copy link to comment
Kurt Vandevelde
mvp_badge
MVP
Rank: #319

In the screen of the external database connection, you can use the advanced settings and specify the parameters you want.


0
0
on 2020-01-21
Copy link to comment
Marcel Hoefs
Rank: #35349

Kurt Vandevelde wrote:

In the screen of the external database connection, you can use the advanced settings and specify the parameters you want.



Thank you for your reply but in the screenshot I only see a field where I can configure the NLS_LANGUAGE parameter. Do you know where I can configure the other NLS parameters and especially the NLS_LENGTH_SEMANTICS parameter?

0
0
on 2020-01-21
Copy link to comment
Nelson André
Rank: #311

Please check if this article helps https://success.outsystems.com/Support/Enterprise_Customers/Maintenance_and_Operations/Configuring_linguistic_sorting_in_an_OutSystems_environment_using_an_Oracle_database

0
0
on 26th Jan
Copy link to comment
Marcel Hoefs
Rank: #35349

Thank you for your reply but this article describes changing the NLS_SORT parameter of the platform database. The setting I would like to change is NLS_LENGTH_SEMANTICS Outsystems uses for the external database.

0
0
on 1st Feb
Copy link to comment