Kasun Kanchana
Member
I have a MySQL database in which some columns contain "Sinhala Unicode" texts. I'm using the JDBCSQL Library to connect this MySQL database with my B4J application.
Here is the table structure:
I have changed the database character set to 'utf8' and the collation to 'utf8_unicode_ci'. My jdbcURL is configured as follows:
When I run the app, the log displays the Unicode characters correctly, but the labels, TextFields, etc., show characters like "හපුà¶à¶½à·š."
Why is this happening?
Here is the table structure:
MYSQL:
CREATE TABLE `tbl_tax_arpa_acres` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`arpa` text CHARACTER SET utf8 COLLATE utf8_sinhala_ci DEFAULT NULL,
`arpa_agent` text CHARACTER SET utf8 COLLATE utf8_sinhala_ci DEFAULT NULL,
`paddy_acres` double(10,2) DEFAULT NULL,
`high_land_acres` double(10,2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
I have changed the database character set to 'utf8' and the collation to 'utf8_unicode_ci'. My jdbcURL is configured as follows:
jdbc url:
Private jdbcUrl As String = "jdbc:mysql://serverIP/mydatabase?characterEncoding=utf8&autoReconnect=true"
When I run the app, the log displays the Unicode characters correctly, but the labels, TextFields, etc., show characters like "හපුà¶à¶½à·š."
Why is this happening?