Physical Column Name Length Limiter in Application Developer
M
Michael BARTLEY
started a topic
12 months ago
Hello
When creating a simple attribute I see that the "physical column name" is limited to 25 characters. Is it possible to increase (or decrease) this? The column name and label can be longer, this can cause truncation of the physical column name.
We use SQL Server and I see that in the INFORMATION_SCHEMA --> COLUMNS view the "Column name" attribute has a length of 128.
Is the 25 character limiter a setting within the application developer, or is this set within the database somewhere? I've gotten this question a couple of times. Please let me know if you need more information. Thanks in advance
Best Answer
A
Alexia SIMOND
said
11 months ago
Hello Michael,
This limitation is there due to security from the dev team to have the ability to handle the different DB types (Oracle, SQLServer, PostgreSQL).
We do have an internal ticket to raise it, if you want me to add you as an interested customer and to communicate the reference, please let me know and I'll convert this topic as a ticket.
This limitation is there due to security from the dev team to have the ability to handle the different DB types (Oracle, SQLServer, PostgreSQL).
We do have an internal ticket to raise it, if you want me to add you as an interested customer and to communicate the reference, please let me know and I'll convert this topic as a ticket.
Thank you and have a good day.
A
Alexia SIMOND
said
11 months ago
Here is Michael's feedback:
Thank you for the clarification. No need to convert this topic to a ticket. have a great day!
Michael BARTLEY
Hello
When creating a simple attribute I see that the "physical column name" is limited to 25 characters. Is it possible to increase (or decrease) this? The column name and label can be longer, this can cause truncation of the physical column name.
We use SQL Server and I see that in the INFORMATION_SCHEMA --> COLUMNS view the "Column name" attribute has a length of 128.
Is the 25 character limiter a setting within the application developer, or is this set within the database somewhere? I've gotten this question a couple of times. Please let me know if you need more information. Thanks in advance
Hello Michael,
This limitation is there due to security from the dev team to have the ability to handle the different DB types (Oracle, SQLServer, PostgreSQL).
We do have an internal ticket to raise it, if you want me to add you as an interested customer and to communicate the reference, please let me know and I'll convert this topic as a ticket.
Thank you and have a good day.
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstAlexia SIMOND
Hello Michael,
This limitation is there due to security from the dev team to have the ability to handle the different DB types (Oracle, SQLServer, PostgreSQL).
We do have an internal ticket to raise it, if you want me to add you as an interested customer and to communicate the reference, please let me know and I'll convert this topic as a ticket.
Thank you and have a good day.
Alexia SIMOND
Here is Michael's feedback:
Thank you for the clarification. No need to convert this topic to a ticket. have a great day!
Michael Bartley
-
Deployment History Date
-
Username in Tomcat Access Logs
-
Is It Possible to Perform Automatic Authentication with The User's Windows Account?
-
Where is the documentation for Version 5.2.5?
-
On Prem Semarchy Authentication using Azure AD?
-
Delete old models
-
Sync production model version with dev
-
Recreate a dev environment. Any side effect?
-
Indexes on xDM database tables
-
What logging technology is used in the Semarchy xDM platform?
See all 82 topics