开发者

SQLite GUIDs not returned on Mac

开发者 https://www.devze.com 2023-03-03 15:37 出处:网络
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

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

精彩评论

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