On an IRIS system, we expect the default string collation for SQL columns to be SQLUPPER. This means WHERE conditions will be case-insensitive. However, when I make a WHERE condition on a SQL procedure that returns a string, it's case sensitive.For example:
Class Sample.Person Extends %Persistent
{
Property Name As %String;
ClassMethod Test() As %String [ SqlProc ]
{
return "Abe Lincoln"
}
} If I query select * from Sample.Person where Name = 'abe lincoln', it will return results where name = "Abe Lincoln". If I query select * from Sample.Person where Sample.
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.jpg)
