using UTF-16 instead of UTF-8 between Stack and Hosted DB

[teriibi]

HI everyone,

Under Community Plus 9 IDE.

Does anyone has good Working experience with LC and Unicode UTF formats so as to tell me :

1)
can UTF-16 format fields in a MariaDB workfine with an LC made app..and data transfers with the UTF-8 encoding function ?

2)
Are there any improoved UTF-8 functions (some new UTF-16 version) to deal in UTF-16 encoding within an APP or between APP and the online DB data exchange ?

or is there an UTF-16 mode for the UTF-8 existing function...

Thanks to everyone

[Mark]

Sure. If the UTF16 encoded data in the MariaDB fields are correct, there is no reason why it wouldn't display correctly in LiveCode.

I don't understand why you mention data transfers separately. This may depend on your server and on the specified data transfer method, a transfer shouldn't affect the data.

I haven't tried displaying emoticons in LiveCode yet. Otherwise, extensions to UTF16 don't imply that software suddenly become incompatible with the UTF16 standard. If you have the right fonts, you can display UTF8 and UTF16 in LiveCode.

Are you aware that you can convert UTF8 to UTF16 and reverse within LiveCode?

Perhaps I could help you better if you asked more specific questions about specific cases that you expect to cause trouble.

Kind regards,

Mark