You cant use a char to do it... ascii '0' is numeric 48.


Your best bet is to use numeric (3,0) and live with whatever it does.

----- Original Message -----
From: <georg_ritter@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, 14 March 2001 01:41
Subject: [ib-support] shortint / short integer / 8-bit integer ?


> Hi,
>
> using IB 6.01, I am trying to store an unsigned 8-bit integer (values
> 0-255) in the database.
> I cannot figure out an easy way to do this - there is no SHORTINT type
> or something like this, and domains with char(1) don't seem to work in
> this case (when I put 0 in such a field, and retrieve it, I get the
> ascii value of 48 which is not what I want).
> Is there a solution? (I have searched previous postings and the
> Internet, without success).
>
> Any help would be appreciated,
> thanks
> Georg
>
> ............
> Georg Ritter
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>