Check your character set/collaton settings for the columns involved.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> I'm using IB 6.02 on W2K, I have a db and I run the following query
> select S.SAID from SALESAREAS S,DOS_CONSTANTS D where D.NAME=S.SANAME
> and D.SHORTCUT=80
> and I get the result SAID=6
> The db has the pagesize 4K.
> Now I backup the db and restore it with 8K pagesize. I run the SAME
> query as above and I get
> Overflow occurred during data type conversion.
> Conversion error from string "".
>
> What am I doing wrong ?