Re: [sqlite] sqlite3.exe and formatting binary (GUID) data

John Machin wrote: > Assuming your guid is a BLOB, then >SELECT other_stuff, QUOTE(guid), etc > will display it as hex e.g. X'01020304' > This is great; now I can see them at least! >> P.S. Of course even better would be the ability to read/write GUIDs as >> properly formatted strings!

Re: [sqlite] sqlite3.exe and formatting binary (GUID) data

On 25/05/2009 2:30 PM, Philip Warner wrote: > I use binary GUID values and when I 'select' them in the sqlite3 shell, > they display as *binary* data, often screwing up the terminal. When I > use .dump, or use .mode tcl I get terminal-friendly output. Is there any > simple way (or just a hack)

[sqlite] sqlite3.exe and formatting binary (GUID) data

Hi, I'm using sqlite3 and am very impressed. But, have one small problem. I use binary GUID values and when I 'select' them in the sqlite3 shell, they display as *binary* data, often screwing up the terminal. When I use .dump, or use .mode tcl I get terminal-friendly output. Is there any simple