Laravel Eloquent accented characters issue

php encoding character-encoding eloquent laravel-eloquent

530 观看


28 作者的声誉

I have a system that was initially built using MeekroDB and have been doing new development, as well as updating original development, to use Eloquent ORM. I have having an issue with an accented e (é) character.

When pull from the database using Eloquent, I get the following: Té

But when pull from the database using MeekroDB, I get: té

I thought the issue might be in passing the data to the front end, but even when printing to the php log I see the same values, so I'm thinking eloquent does some manipulation of a varchar when it's pulled from the database?

In an ideal world, I could properly encode the database value, but that's not a tenable solution at this time. Using the meekro pulled value would also not be a terribly workable solution.

Has anyone else run into this issue before? Have any suggestions where to look ? Thanks.

作者: Alex Barrett 的来源 发布者: 2017 年 12 月 27 日

回应 1


28 作者的声誉

I found the issue.

The issue was that MeekroDB's encoding was set to utf8 where eloquent's was set to latin1.

作者: Alex Barrett 发布者: 2017 年 12 月 27 日