Hi, Can you declare it as a VARCHAR(1)? Or try "select cast(recipt_type as varchar(1)) from ...." Regards., ...michal
Dan Cooperstock napisał(a): > Here's a bit more info: I just walked through the execution of "SELECT > RECEIPT_TYPE FROM RECEIPT WHERE ..." in the debugger, and what happens is > that it is still selecting 4 characters, e.g. "D ", when the column was > declared as CHAR(1) and the real value should be "D". Obviously it ends up > comparing that to the schema, seeing it's too long, and giving the error > message I have quoted. > > - Dan. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
