javascript python java c# php android html jquery c++ css ios mysql sql r node.js arrays reactjs c asp.net json ruby-on-rails .net sql-server swift python-3.x objective-c django angular angularjs excel regex pandas ruby iphone ajax linux xml vba asp.net-mvc spring laravel database wordpress typescript string wpf mongodb windows xcode postgresql bash oracle git vb.net amazon-web-services multithreading list firebase flutter eclipse spring-boot dataframe azure react-native algorithm docker macos forms image visual-studio scala powershell function twitter-bootstrap numpy api performance selenium winforms python-2.7 matlab vue.js sqlite apache hibernate entity-framework loops rest shell facebook express android-studio csv linq maven qt swing unit-testing file tensorflow

[ACCEPTED]-How to display blob value using x'abc' binary string literal syntax?-sqlite

Accepted answer
Score: 58 
select quote(uid) from blobs

returns: 

X'0123456789ABCDEF0123456789ABCDEF'

and if you really need it in lowercase, you 1 can use:

select lower(quote(uid)) from blobs
Source: stackoverflow.com

More Related questions

Python, Sqlite3 - How to convert a list to a BLOB cell

django error 'too many values to unpack'

SQLite parameter substitution and quotes

How to insert duplicate rows in SQLite with a unique ID?

Create SQLite database in memory

How to discover table properties from SQLAlchemy mapped object

How would you convert secs to HH:MM:SS format in SQLite?

Are there any reserved words in SQLite?

Only first table in create table statement being created

Why do I get a "sqlite3: not found" error on a rooted Nexus One when I try to open a database using the adb shell?