ArcGIS Pro 3.4 API Reference Guide
ArcGIS.Core.Data Namespace / SQLSyntax Class / GetSupportedStrings Method
A constant that specifies the type of SQL string.
Example Version

GetSupportedStrings Method
Gets all of the supported strings corresponding to sqlStringType, e.g., SQLStringType.InvalidCharacters. This method must be called on the MCT. Use QueuedTask.Run.
Syntax
public IReadOnlyList<string> GetSupportedStrings( 
   SQLStringType sqlStringType
)

Parameters

sqlStringType
A constant that specifies the type of SQL string.

Return Value

A IReadOnlyList of supported strings corresponding to sqlStringType.
Exceptions
ExceptionDescription
sqlStringType is not a field of SQLStringType.
A geodatabase-related exception has occurred.
Example
Searching a Table for non-Latin characters
using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri("path\\to\\sde\\file\\sdefile.sde"))))
using (Table table = geodatabase.OpenDataset<Table>("TableWithChineseCharacters"))
{
    // This will fail with many database systems that expect Latin characters by default
    string incorrectWhereClause = "颜色 = '绿'";

    // Correct solution is to prepend the 'National String Prefix' to the attribute value
    // For example, with SQL Server this value is 'N'
    // This value is obtained using the SQLSyntax class
    string nationalStringPrefix = "";
    SQLSyntax sqlSyntax = geodatabase.GetSQLSyntax();
    nationalStringPrefix = sqlSyntax.GetSupportedStrings(SQLStringType.NationalStringPrefix).First();

    // This Where clause will work
    QueryFilter queryFilter = new QueryFilter()
    {
        WhereClause = "颜色 = " + nationalStringPrefix + "'绿'"
    };
}
Requirements

Target Platforms: Windows 11, Windows 10

ArcGIS Pro version: 3 or higher.
See Also