General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How To Read High Ascii Character In Sqlite
Database used is SQLITE3
connection string is
"DRIVER=SQLite3 ODBC Driver;Database=simpleac.db;StepAPI=0;SyncPragma=FULL;NoTXN=0;Timeout=;ShortNames=1;LongNames=0;NoCreat=0;NoWCHAR=1;JournalMode=;LoadExt=;"
If I directly insert with character string which contain ascii character value above 128 and try to retrieve them they are not stored as they were sent.
But if I create an remote view then they are stored as entered.
SQLite3 stores text in UTF8.
What is the difference between the insert/update sent by me and that of view.
-----------------------------------
Rajesh Halyal
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only