I have some tables which are maintained programmatically, and which have a text field in which I store a block of text made up of a series of null-separated strings. I am able to read and write these fields through the program without problem; reading via sqlite3_column_text() and sqlite3_column_bytes() APIs, writing via sqlite3_bind_text(). I cannot figure out a way to extract these fields from the sqlite3 shell, though, even via .dump.
Is there any clever command line or pragma trickery that can cause the shell to write all the characters in a text field to the screen or even stdout? Maybe a way of making the sqlite3 shell treat these fields as BLOBS, or hooking a filter into the shell some way? Thanks for any insight or assistance. -evan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
