SQL 490 symbols limit about restforms

[eduard93]

Add info about 490 and truncate to descriptions

[adaptun]

What limit is this? Is this system limit?

[eduard93]

@adaptun you can't ORDER BY on fields with values longer then ~490 symbols

[adaptun]

Depends on collation and symbols.

On cyrillic3 if length of string is >~250 and it contains only latin characters you cannot order by it either.
On cyrillic4 you can.

[adaptun]

for col = "Cache standard", "Cyrillic1", "Cyrillic3", "Cyrillic4" {
   kill ^a
    write ##class(%GlobalEdit).Create(,"a",##class(%Collate).DisplayToLogical(col)), " "
    for letter = "F","Ф" {
        try {
            for i=1:1:1000 {
                kill s
                set $Piece(s, letter, i + 1) = ""
                set ^a(s) = 1
            }
        } catch (ex) {
            if ex.Name [ "<SUBSCRIPT>" {
                write col, " ", letter, " ", i,!
            }
        }
    }
 }

---

USER>d ^test
1 Cache standard F 509
Cache standard Ф 508
1 Cyrillic1 F 254
Cyrillic1 Ф 254
1 Cyrillic3 F 255
Cyrillic3 Ф 509
1 Cyrillic4 F 509
Cyrillic4 Ф 508

[eduard93]

Even less, as in SQL global key is not only offending value but something else too.

[adaptun]

Generally, this should be solved by setting SQL collation for the property
http://docs.intersystems.com/cache201513/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_order#RSQL_C61762

[eduard93]

Done