开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜