Unlimited String Behavior
1 Introduction
In the domain model, you can select the attribute type String and set its length to Unlimited. The underlying implementation of this attribute differs per database.
2 Behavior of Unlimited Strings by Database Type
The following section describes the default behavior of the databases supported by Mendix.
2.1 HSQLDB, PostgreSQL, and MariaDB
You can sort by and compare unlimited strings. Unlimited strings can be used in uniqueness constraints.
2.2 SQL Server and MySQL
You can sort by and compare unlimited strings. Uniqueness constraints on unlimited strings are not supported.
2.3 Oracle
You can sort by unlimited strings. Uniqueness constraints on unlimited strings are not supported. Comparison of unlimited strings is not supported.
2.5 SAP HANA
Sorting by and comparison of unlimited strings is not supported. Uniqueness constraints on unlimited strings are not supported.
3 Overview of Unlimited String Behavior
Database Type | Comparison | Sorting | Uniqueness constraint |
---|---|---|---|
HSQLDB | Supported | Supported | Supported |
POSTGRESQL | Supported | Supported | Supported |
MARIADB | Supported | Supported | Supported |
MYSQL | Supported | Supported | Not supported |
ORACLE | Not supported | Supported | Not supported |
SAP HANA | Not supported | Not supported | Not supported |
SQL SERVER | Supported | Supported | Not supported |
Feedback
Was this page helpful?
Glad to hear it! Thank you for your response.
Sorry to hear that. Please tell us how we can improve.