Adding text - Locale issue lazarus / 31-LCL ---------------------------------------------------------------------- JZS ยท 2015-04-26 12:40 Hello everyone, Until recently I was thinking that I understand UTF8 and system locale, but I discovered there is a missing link in my applications. Some of my clients use Arabic, so I use UTF8 collation in my DB tables, and when viewing the data from my application everything looks OK as long as the system locale is set to Arabic. But there is a scenario that I need to handle, apparently is annoying to miss. When a user with System Locale set to Arabic adds some arabic text, all other users, with Arabic Locale, are able to read, but non-arabic locale see ?????, instead of the real text, also the other way around, non-arabic locale users when adding arabic text all non-arabic locale users are able to read, but those who have system locale set to arabic see ?????. How to make the text appears in both configuration? I know the difference in bytes and char representation about UTF8 and ASCII but how can I enable both users to see what others enter regardless the system locale: 1. Does it involve collation of my DB Tables (cp1256 <=> UTF8)? 2. Or, I encode (SysToUTF8?) when adding arabic text to my UTF8 Collation Tables? Appreciate any input on this subject. I use Laz 1.4 & MariaDB 10. Regards,