SQLite database supporting Unicode data

by

SQLite always stores text data as Unicode, using the Unicode encoding specified when the database was created. The database driver itself takes care to return the data as the Unicode string in the encoding used by your language/platform.

If you have conversion problems, either your application tried to store an ASCII string without converting it to Unicode, or you tried to read one value and force a conversion on it.

SQLite uses a kind of dynamic typing, where each value is stored using a specific storage class. A column’s type specifies the affinity or how the value is treated. For example:

A column with NUMERIC affinity may contain values using all five storage classes. When text data is inserted into a NUMERIC column, the storage class of the text is converted to INTEGER or REAL

There are five storage classes, NULL, INTEGER, REAL, TEXT, BLOB. TEXT stores string data using the Unicode encoding specified for the database (UTF-8, UTF-16BE or UTF-16LE).

What specific problem are you facing, or is this a general question?

More Related Contents:

  1. SQLite how to refer to column name by a query
  2. How do I unlock a SQLite database?
  3. “Insert if not exists” statement in SQLite
  4. How do I make an UPDATE while joining tables on SQLite?
  5. SQLite Concurrent Access
  6. System.Data.SQLite Close() not releasing database file
  7. Escape single quote character for use in an SQLite query
  8. INSERT IF NOT EXISTS ELSE UPDATE?
  9. Sqlite LIMIT / OFFSET query
  10. Set start value for AUTOINCREMENT in SQLite
  11. How to use ROW_NUMBER in sqlite
  12. Android – Pulling SQlite database android device
  13. ALTER COLUMN in sqlite
  14. SQLite error ‘attempt to write a readonly database’ during insert?
  15. Efficient paging in SQLite with millions of records
  16. Sqlite group_concat ordering
  17. How to get a list of column names
  18. is there a limit to the size of a SQLite database?
  19. sqlite – How to get INSERT OR IGNORE to work
  20. How do I add a new column in between two columns?
  21. Creating stored procedure and SQLite?
  22. How Scalable is SQLite? [closed]
  23. change sqlite file size after “DELETE FROM table”
  24. Are there any reserved words in SQLite?
  25. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  26. Modify a Column’s Type in sqlite3
  27. SQLite accent-insensitive search
  28. How to set unique constraint over multiple columns when any one can be null?
  29. sql query – how to apply limit within group by
  30. Creating stored procedure in SQLite

Leave a Comment