Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Nael.Saeed's avatar

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>

0 likes
0 replies

Please or to participate in this conversation.