Re: [sqlite] Hex value with DEFAULT Constraint

2013-10-29 Thread Hick Gunter
a,b,hex(c) from x; a b hex(c) - - -- test 1 FF -Ursprüngliche Nachricht- Von: Igor Tandetnik [mailto:i...@tandetnik.org] Gesendet: Dienstag, 29. Oktober 2013 13:18 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Hex value with DEFAULT Constraint On 10/29/2013 8:09 AM,

Re: [sqlite] Hex value with DEFAULT Constraint

2013-10-29 Thread Igor Tandetnik
On 10/29/2013 8:09 AM, techi eth wrote: Is it possible to attach hex value with DEFAULT constraint? There are no hex literals in SQLite, whether for use with DEFAULT constraint or otherwise. You will have to specify your numeric constants in decimal. -- Igor Tandetnik

[sqlite] Hex value with DEFAULT Constraint

2013-10-29 Thread techi eth
Is it possible to attach hex value with DEFAULT constraint? I am getting return error code as SQLITE_ERROR & detail error message as "unrecognized token". ___ sqlite-users mailing list sqlite-users@sqlite.org