Aug 20, 2017
0
Level 3
QueryException for the Arabic ZERO CHARACHTER
Hi there,
I am having this serious error showing up whenever a user uses the ARABIC ZERO character in comments or any text, an example:
SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xD9 ' for column 'description' at row 1 (SQL: update `services` set `description` = sdadasdasda sads adasd asd asd asd asd asd
asd asd asd asd asd asd asd asd asd asd asd asd asd asda d as
d asd asd asd asd asd asd asd asd asd as
das asd asd asd asd asd asd asd asd asd as
asd asd asd asd asdas sdadasdasda ١� , `status` = pendding.edited, `updated_at` = 2017-08-20 14:38:29 where `id` = 3)
i am using utf8mb4_unicode_ci collation for tables and columns. I can't figure out how to solve this problem.
any idea?
by the way I have a filed of varchar which is a title for the service. this filed accepted the Arabic zero. but still other varchar fields show the same error when using it>
Please or to participate in this conversation.