Emoticons
Posted: Thu Nov 30, 2023 6:13 am
Hi!
I'm trying to store in text fields some special symbols AKA emoticons (sure along with other latin and cyrillic chars). And I can't do it yet
Right now I'm testing the following dummy set: Hi-
π
-ΠΠΎΠ½Π΅Ρ
My steps just after running the new nuBuilder instance v. 4.5.8.1:
1. Check MariaDb settings in phpAdmin:
1.1. Server connection collation: utf8mb4_unicode_ci
1.2. Database sqlu collation: utf8mb4_general_ci
2. Create by phpAdmin a new table tbl_Test:
2.1. CREATE TABLE `sqlu`.`tbl_Test` (`id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(1000) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
2.2. Checked a collation: tbl_Test.name is utf8mb4_general_ci
3. Insert 1 row by phpAdmin: INSERT INTO `tbl_Test` (`id`, `name`) VALUES (NULL, 'Hi-π-ΠΠΎΠ½Π΅Ρ')
4. Test inserting:
4.1. SELECT name FROM tbl_Test;
4.2. Everything is OK: > Hi-π-ΠΠΎΠ½Π΅Ρ
That's fine here
===================
Next steps in nuBuilder:
5. Create a new FastForm for tbl_Test with only one text field 'name'
6. Browse it. I see: Hi-?????????-ΠΠΎΠ½Π΅Ρ
7. Trying inserting a new record with the same original test string using this FastForm.
7.1.Nothing inserted, but nuDebugResults reports:
8. OK, I've changed collation for zzzzsys_debug table to utf8mb4_general_ci using phpAdmin and restarted services.
9. No changes
I'm trying to store in text fields some special symbols AKA emoticons (sure along with other latin and cyrillic chars). And I can't do it yet
Right now I'm testing the following dummy set: Hi-
π
-ΠΠΎΠ½Π΅ΡMy steps just after running the new nuBuilder instance v. 4.5.8.1:
1. Check MariaDb settings in phpAdmin:
1.1. Server connection collation: utf8mb4_unicode_ci
1.2. Database sqlu collation: utf8mb4_general_ci
2. Create by phpAdmin a new table tbl_Test:
2.1. CREATE TABLE `sqlu`.`tbl_Test` (`id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(1000) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
2.2. Checked a collation: tbl_Test.name is utf8mb4_general_ci
3. Insert 1 row by phpAdmin: INSERT INTO `tbl_Test` (`id`, `name`) VALUES (NULL, 'Hi-
π-ΠΠΎΠ½Π΅Ρ')4. Test inserting:
4.1. SELECT name FROM tbl_Test;
4.2. Everything is OK: > Hi-
π-ΠΠΎΠ½Π΅ΡThat's fine here
===================
Next steps in nuBuilder:
5. Create a new FastForm for tbl_Test with only one text field 'name'
6. Browse it. I see: Hi-
?????????-ΠΠΎΠ½Π΅Ρ7. Trying inserting a new record with the same original test string using this FastForm.
7.1.Nothing inserted, but nuDebugResults reports:
Code: Select all
[0] : ===PDO MESSAGE===
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x92\x8B\xF0\x9F...' for column `sqlu`.`zzzzsys_debug`.`deb_message` at row 1
===SQL===========
INSERT INTO zzzzsys_debug (zzzzsys_debug_id, deb_message, deb_added, deb_user_id) VALUES (:id , :message, :added, :user_id)
===BACK TRACE====
/var/www/html/core/nudatabase.php - line 496 (nuRunQuery)
/var/www/html/core/nudatabase.php - line 546 (nuDebugResult)
/var/www/html/core/nudatabase.php - line 157 (nuDebug)
/var/www/html/core/nudata.php - line 580 (nuRunQuery)
/var/www/html/core/nudata.php - line 459 (nuUpdateDatabaseExecStatements)
/var/www/html/core/nuapi.php - line 116 (nuUpdateDatabase)9. No changes