sqlite-net
sqlite-net copied to clipboard
Getting RTL/Arabic Text from sqliteDB using this library flips character
While trying to get RTL text using the library, the string direction is changed from RTL to LTR
This is the output when I use the terminal
% sqlite3 StreamsDb.db sqlite> select * from StreamTable where room_name = "WeTech2";
It works just fine
This Library
Here's the code I tried to use
var x = _db.Query<StreamRow>("select * from StreamTable where room_name = ?", roomName);
System.Console.WriteLine(x[0].Translation);
var y = _db.ExecuteScalar<string>("select translation from StreamTable where room_name = ?", roomName);
System.Console.WriteLine(y);
And the output is as follows for both statements
ﻚﻟﺫ ﻝﺎﻴﺣ ﻞﻌﻔﺘﺳ ﺍﺫﺎﻣ ،ﺎﻨﻫ ﺺﻨﻟﺍ