At 07:21 PM 1/23/2003 +0100, Henrik Sitter wrote:

>When using the Firebird API to retrieve data from tables, I get only BS
>back in columns with numerical data, but it works perfectly well with
>columns that store char or varchar.

Binary BS is sometimes difficult to tell from binary data. For
example, if you define a field as NUMERIC (9, 3) and store in it
the value 10, you'll get the value 10000 come back. Within the
database that field is understood to evaluate to its stored
value * 10**-3.



Regards,

Ann
www.ibphoenix.com
We have answers.