Subject | String overflow |
---|---|
Author | Maximiliano Robaina |
Post date | 2011-12-07T12:22:13Z |
Hi,
I'm a little bit confuse here. This select statement raise this error:
SELECT COUNT(*) FROM "AFILIADO" INNER JOIN "PERSONA" ON
("AFILIADO"."PER_ID" = "PERSONA"."PER_ID") WHERE "PERSONA"."FULL_NAME"
CONTAINING
'0........................................................................................................................................'
-802L, 'String overflow: value 137 bytes long cannot fit in character
field of maximum length 111
Obviously, FULL_NAME is a varchar(111).
This select statement is part of a django (python) project. I'm using
django-firebird built on top of kinterbasdb. The production server is a
Windows 2003 Server with Firebird 2.1 SS.
But, if I run this select, for example, using FlameRobin I don't get
that error.
Also, I test this in my laptop with Ubuntu 11.04 and Firebird 2.5 with
the same result.
What can be wrong?
Any help will be appreciated.
Thanks in advance.
---
Maxi.
I'm a little bit confuse here. This select statement raise this error:
SELECT COUNT(*) FROM "AFILIADO" INNER JOIN "PERSONA" ON
("AFILIADO"."PER_ID" = "PERSONA"."PER_ID") WHERE "PERSONA"."FULL_NAME"
CONTAINING
'0........................................................................................................................................'
-802L, 'String overflow: value 137 bytes long cannot fit in character
field of maximum length 111
Obviously, FULL_NAME is a varchar(111).
This select statement is part of a django (python) project. I'm using
django-firebird built on top of kinterbasdb. The production server is a
Windows 2003 Server with Firebird 2.1 SS.
But, if I run this select, for example, using FlameRobin I don't get
that error.
Also, I test this in my laptop with Ubuntu 11.04 and Firebird 2.5 with
the same result.
What can be wrong?
Any help will be appreciated.
Thanks in advance.
---
Maxi.