Subject String overflow: while using CONTAINING
Author jasperelzinga
We get a string overflow error while we are trying to query our memo field
The memo field is a domain witch we created like this:
"CREATE DOMAIN MEMO AS BLOB SUB_TYPE TEXT CHARACTER SET NONE"

This is the query we use on the memo field:
SELECT DISTINCT Kenmerk.id FROM Kenmerk WHERE Kenmerk.memo
CONTAINING 1111111111111111111111111111111 AND Kenmerk.deleted=0
ORDER BY Kenmerk.naam ASC, Kenmerk.id ASC

The Error we get is:
String overflow: value 31 bytes long cannot fit in character field of
maximum length 30 (value is '1111111111111111111111111111111').