Azfar Kashif
Reputation: 193
How to specify sqlite database collation
I've worked with mysql and SQL server. But I'm getting an app made and my app guys don't seem to know much about sqlite.
Like SQL server and mysql, you can specify the collation of sqlite, right? I need my sqlite databases to be in utf-8 encoding so they can store special characters, Japanese, Chinese etc.
How do you do that? Through code, of course.
Upvotes: 3
Views: 1665
Answers (1)
CL.
Reputation: 180020
SQLite uses UTF-8 by default.
Collations are used only to use different comparison algorithms.
Upvotes: 3
Related Questions
- Improve INSERT-per-second performance of SQLite
- How to change collation of database, table, column?
- How can I list the tables in a SQLite database file that was opened with ATTACH?
- How do I check in SQLite whether a table exists?
- How can I do Base64 encoding in Node.js?
- SQLite primary key on multiple columns
- MySQL: Get character-set of database or table or column?
- How can I avoid concurrency problems when using SQLite on Android?
- Database agnostic way to say I want a column to be UTF-8 in SqlAlchemy?