[PC6.1b7] Save emoji - generate error

Phoca Cart - complex e-commerce extension
mjmartino
Phoca Enthusiast
Phoca Enthusiast
Posts: 92
Joined: 10 Jun 2019, 15:53

[PC6.1b7] Save emoji - generate error

Post by mjmartino »

HI.
In PC6.b7 if i try save emoji (kay and hammer) i have error.
The save failed with the following error: Incorrect string value: '\xF0\x9F\x9B\xA0\xEF\xB8...' for column `database`.`XXX_phocacart_products`.`description_long` at row 1.
I think the setting is too restrictive.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49279
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: [PC6.1b7] Save emoji - generate error

Post by Jan »

Hi, are you sure, you database is correctly set or your Joomla! I don't have any problem with saving emoji in description long:

Image

Jan
If you find Phoca extensions useful, please support the project
mjmartino
Phoca Enthusiast
Phoca Enthusiast
Posts: 92
Joined: 10 Jun 2019, 15:53

Re: [PC6.1b7] Save emoji - generate error

Post by mjmartino »

We have
utf8mb3_general_ci
but probably for emoij we need 4bytes.
utf8mb4_general_ci

Thanks Jan.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49279
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: [PC6.1b7] Save emoji - generate error

Post by Jan »

OK
If you find Phoca extensions useful, please support the project
Post Reply