sqlite-net icon indicating copy to clipboard operation
sqlite-net copied to clipboard

Getting RTL/Arabic Text from sqliteDB using this library flips character

Open saamerm opened this issue 1 year ago • 0 comments

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";

image

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 ﻚﻟﺫ ﻝﺎﻴﺣ ﻞﻌﻔﺘﺳ ﺍﺫﺎﻣ ،ﺎﻨﻫ ﺺﻨﻟﺍ image

saamerm avatar Jun 10 '24 12:06 saamerm