B4J Question Arabic font from data using SQLite did not display correctly

[ctnm]

Hi,

I would like to ask a question.

I have a sqlite database that consist of multifont data. One of it is Arabic font. I have designed an interface to display the data into Table View. The data is displayed but for the Arabic data the are error.

The Arabic data is displayed as a separate single character not as word. Did B4J need a setting to make the Arabic data display correctly?

Tq.

 

[giga]

This maybe a Sqlite issue. check this

http://stackoverflow.com/questions/13862930/sqlite-database-in-persian-language

 

[Troberg]

The first thing to try is to display the text without getting it from the database, just setting it in the code instead.

That will neatly tell you if the problem is in SQLite or in the display.

 

[ctnm]

Previously, I have been done a program using B4A and there is no problem calling the database.
And I'm doing similar programming using B4J but this problem occur.

Troberg: I'm sorry but could you explain what do you mean by 'just setting it in the code instead.'.
If possible could you give an example.

 

[Troberg]

Instead of storing the text in the database, then retrieving it to show it, just do a:

textbox.text="My arabic text"

That way, you'll know if the database somehow mangles it, or if it's the display of the text that's the problem. A very telling test.

 

[ctnm]

I just realize...when i try to enter or input Arabic text into a textbox, the Arabic font also become separate character.
I just wonder is B4J need font setting?

 

[Erel]

Try to change the font: https://www.b4x.com/android/forum/threads/how-to-set-font-name-in-textarea.36040/#post-211544