DMS: Incorrect characters with SQLite3.exe for SQlite DB
edited Jan 13, 2014 12:14AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 1 commentAnswered ✓
Hi All,
I did some tests with SQLite database in 11gR2 with some records that contains accents like as : "éééèèàà"
Side Oracle database , it appears correctly , but side SqLite db not ( using SQLite3.exe), the records are truncated.
Oracle Database is set with following NLS :
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8MSWIN1252
SQLite Db set with UTF-8 by default :
- On client , Open cmd box and call SQLite3.exe + your SqliteDb file :
sqlite> select * from TESTNLS;
1 éèà test
2 ééééÃ
Note that with SQLite manager from FireFox the records/datas are displayed correctly.
How to displays the correct characters with SQLite3.exe for SQlite DB ?
I did some tests with SQLite database in 11gR2 with some records that contains accents like as : "éééèèàà"
Side Oracle database , it appears correctly , but side SqLite db not ( using SQLite3.exe), the records are truncated.
Oracle Database is set with following NLS :
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8MSWIN1252
SQLite Db set with UTF-8 by default :
- On client , Open cmd box and call SQLite3.exe + your SqliteDb file :
sqlite> select * from TESTNLS;
1 éèà test
2 ééééÃ
Note that with SQLite manager from FireFox the records/datas are displayed correctly.
How to displays the correct characters with SQLite3.exe for SQlite DB ?
0