2009/12/9 liubin liu <7101...@sina.com>: > > sqlite> INSERT OR REPLACE INTO periods_value VALUES (0, 1, > x'000102030400a0afaabbaa'); > sqlite> > sqlite> SELECT * FROM periods_value; > 0|1| > sqlite> > > how to show the blob data?
Select id, valid, hex( value ) from periods_value; Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users