Text properties Ansi, UTF-16

berndgoedecke

Active Member
Licensed User
Longtime User
It would be nice to have the following, additional properties for the TextBox:
bold
italic
and for file open:
cASCII already exists, but
Ansi and UTF-16 left.


Best Regards
berndgoedecke
 

berndgoedecke

Active Member
Licensed User
Longtime User
Ansi and UTF-16

and what is about Ansi and UTF-16 - file open
Or is there an other way or Lib to convert to
UTF-8.
It's because of the UTF-16 encoded SQLite Dtabase.
Showing datas in the textbox let fail the special letters like "ä" "ö" "ü" etc.
 

Erel

B4X founder
Staff member
Licensed User
Longtime User
It is possible to convert a complete file from UTF-16 to UTF-8 (using BinaryFile and Bitwise libraries).
However, if this is a database file you can't treat it as a text file.
Please try the following connection string:
Con.Open("Data Source = " & AppPath & "\Northwind.sl3;UseUTF16Encoding=True")

Replace the database name with your database file.
 

BjornF

Active Member
Licensed User
Longtime User
I feel like I am missing something here. :confused:

"It's because of the UTF-16 encoded SQLite Dtabase.
Showing datas in the textbox let fail the special letters like "ä" "ö" "ü" etc."

I can enter ö, ä, å etc in a textbox, store that in a SQLite database and close the program, open it again and retrieve the letters to a textbox (via a table) without any problems and without using the "UseUTF16Encoding=True".

all the best / Björn
 
Top