Why doesn't mysql skip french text?

Question

MySQL

The site is multilingual. Texts in any language except French are added to the database.
I get the error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'French string'..."
Encoding is utf8.
Comparison for utf8_unicode_ci table.
What could be the problem?

Answer 1

Escape apostrophes and other special characters

Answer 2

Does the string itself contain apostrophes by any chance?

Answer 3

Use libraries that automatically screen everything for you. And more precisely, as far as I remember, there are unprepared requests where escaping is not necessary, since the data is transmitted separately.

Answer 4

I'm most likely wrong, but... what version of php?