W
W
WebDev2015-12-23 11:08:09
MySQL
WebDev, 2015-12-23 11:08:09

Krakozyabry when inserting into the database?

Hello, I began to notice that sometimes krakozyabrs get into the database, although the input is plain text. For example, this sentence "We are proud to show you first real-life pictures of already produced Behemoth „Live at the BBC” limited vinyl/CD EP" was added to the database like this "We are proud to show you first real-life pictures" of already produced Behemoth "Live at the BBC" limited vinyl/CD EP". Immediately I tried to manually insert this line into the database and it was inserted correctly, without bugs. What can be wrong? Base in utf_8_general_ci, on the laravel client, writing to the base through its eloquent orm

Answer the question

In order to leave comments, you need to log in

2 answer(s)
W
wol_fi, 2015-12-23
@wol_fi

most likely the connection goes through PDO, and there you also need to specify the encoding when connecting.
dig in the direction of the configs, maybe there is a way to set the encoding.

M
Mokhirjon Naimov, 2015-12-24
@zvermafia

Try utf8_unicode_ci

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question