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