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

Reply via email to