Well,

jasperelzinga schrieb:

> 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

wenn you ask for a value in a memo containing strings then it would be a
good idea to pass the parameter as a string itself and not as an integer.

If you use

SELECT DISTINCT Kenmerk.id FROM Kenmerk WHERE Kenmerk.memo
CONTAINING '1111111111111111111111111111111' AND Kenmerk.deleted=0

it should work.

Luc.