SQLite GUIDs not returned on Mac
I have a 开发者_高级运维SQLite v3 database, using GUID's as row identifiers.
Something strange is happening when I query the table on a mac, it returns strange ASCII code in the ID Column where the GUID is supposed to be...
See image: http://i51.tinypic.com/2s0mtyx.png
I've read that it has something do to with BinaryGUID=false setting but not sure...
try
select hex(Id) from tbIF_PremiumRates
I suspect the tool you are using is treating a blob column as text
精彩评论