Igor Tandetnik wrote:
> No, there's no syntax for integral hexadecimal literals. There is a blob
> literal x'B40000', but it doesn't behave like a number (e.g. you can't
> do arithmetic on blobs). Bottom line, the only option is to use plain
> vanilla decimal numbers.
>
Thanks for the response, Igor. That tells me what I need.
Regards,
Ben
> Ben Atkinson wrote:
> > Sorry for the newbie SQL question. I'm trying to use the INSERT INTO
> > statement with a hexadecimal literal. I want to accomplish something
> > like this:
> >
> > INSERT INTO TruckDefaultsTable VALUES ( 'AirPressureTime', 0,
> > 0xB40000);
> >
> > Does SQL have a hex literal sequence that serves the same role as
> > "0x" in C?
>
> No, there's no syntax for integral hexadecimal literals. There is a blob
> literal x'B40000', but it doesn't behave like a number (e.g. you can't
> do arithmetic on blobs). Bottom line, the only option is to use plain
> vanilla decimal numbers.
>
> > I could express the value in decimal as 11796480, but that's pretty
> > awkward since the actual value I'm putting into the table is a Linux
> > timeval structure. It just makes more sense as hex.
>
> How come you need to type these timestamps in by hand? When you work
> with SQLite programmatically, you just use int variables and such -
> there's almost never a need to represent the number as string, whether
> decimal or hex.
>
> Igor Tandetnik
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
