Hi,

How to specify a hexadecimal value in the default by create of a table ?  I
try thinks like:

create table Test ( [Name] char, [Color] integer default 0xFFFFFF );

But have syntax errors. When I leave out the 0 then the xFFFFFF seems to be
stored as a string. it is just that 0xFFFFFF makes more sence that 16777215,
specially if it is a color.
-- 
View this message in context: 
http://www.nabble.com/default-value-in-hex-tf1882855.html#a5147011
Sent from the SQLite forum at Nabble.com.

Reply via email to