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.