Text properties Ansi, UTF-16

[berndgoedecke]

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

 

[Erel]

Note that you could set bold and italic (and other properties) using FormLib library.

 

[berndgoedecke]

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]

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]

I feel like I am missing something here.

"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

 

[Erel]

Basic4ppc uses UTF-8 by default.
UTF-8 supports all characters.
UseUTF16Encoding should be used when you get a database that you didn't create (at least not with Basic4ppc) and it is encoded with UTF-16.

 

[BjornF]

Aha, then I understand. Thanks.