select quote(uid) from blobs
returns:
X'0123456789ABCDEF0123456789ABCDEF'
and if you really need it in lowercase, you can use:
select lower(quote(uid)) from blobs
More Related Contents:
- near “varchar”: syntax error [closed]
- How do I rename a column in a SQLite database table?
- How do I check in SQLite whether a table exists?
- How to set Sqlite3 to be case insensitive when string comparing?
- Accessing an SQLite Database in Swift
- Import CSV to SQLite
- Difference between 2 dates in SQLite
- Select random row from a sqlite table
- Update with Join in SQLite
- Can I read and write to a SQLite database concurrently from multiple connections?
- How do I store and retrieve a blob from sqlite?
- Sqlite primary key on multiple columns
- Store boolean value in SQLite
- Can SQLite support multiple users?
- SQLite add Primary Key
- How delete table inner join with other table in Sqlite?
- Export from sqlite to csv using shell script
- SQLite: How do I save the result of a query as a CSV file?
- Create table in SQLite only if it doesn’t exist already
- How do DATETIME values work in SQLite?
- Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
- Is there a boolean literal in SQLite?
- sqlite get ROWID
- How to have an automatic timestamp in SQLite?
- svn cleanup: sqlite: database disk image is malformed
- SELECT INTO statement in sqlite
- Integration Testing Entity Framework code first with in-memory database
- DbFunctions.TruncateTime LINQ equivalent in EF CORE
- How to get the number of rows of the selected result from sqlite3?
- How to get the last index of a substring in SQLite?