I have several programs written in Lazaru and Microsoft Visual Studio VB.NET and C# in PHP and Elevate Web Builder. Polish characters are well read everywhere.
I am asking for help. I would like to start my adventure with Xojo.
How are you putting the data into the database in the first place. If you are importing files that are not encoded in UTF8 then it will not magically become UTF8 by storing it into the database.
If it is data collected over many years then you may have some records that are in UTF8 and others that are in a differing encoding. That is typically very problematic and would likely need a record by record manual inspection to test.
When you read data from the database, Xojo does not automatically assign an encoding to it, regardless of how you have defined the database. Therefore, the encoding will be Nil. You must assign an encoding to the string with DefineEncoding.
You said MySQL and was pointing to a MSSQL thread.
Maybe you still need proper settings in your DB Tables?
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `mytable`;
CREATE TABLE `mytable` (
`rowid` bigint(20) NOT NULL AUTO_INCREMENT,
`mytxt` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`rowid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;