Subject | String overflow: while using CONTAINING |
---|---|
Author | jasperelzinga |
Post date | 2007-12-19T12:40:19Z |
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').
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').