search

Protoqol / Prequel

Prequel for Laravel. Clear and concise database management. Unfortunately, not actively maintained due to time constraints.
https://packagist.org/packages/protoqol/prequel
MIT License
1.54k stars 96 forks source link

[BUG] Malformed UTF-8 characters #88

Closed msbtec closed 2 years ago

msbtec commented 4 years ago

There was an error while loading this table. See the following: Malformed UTF-8 characters, possibly incorrectly encoded

How to fix to read my tables with this encode?

QuintenJustus commented 4 years ago

Could you provide some more details?

omidMolaverdi commented 4 years ago

See this for example:

These are Arabic characters. ` Idint(11) Namemediumtext Chlenint(11) status
  2 (???????)? ?????? ?????? ???? ?????? ?????? ????? 49 0 1
  3 /?????????? ????/??? ??????????? ??????? ?????????? ??????? ????????? ????? ????? 81 0 1
  4 /???? ?????? ???? ???? /? ??????? ?????? ????? ???? ????? 57 0 1
  5 /???? ?????? /???? ????? ???? ????? ??????? ????? ???? ??????? ????? 68 0 1
  6 /?????? / ??????? ???????? ???????? ?????? ???????? ????? 57 0 1
  7 /????? ???? ?????? /????? ??? ????? ???????????? ???????? ????????? ????????? ????? ????? 89 0 1
  8 /?????????/???? ????? ???? ????? ??????? ????? ???? ??????? ????? 65 0 1
  9 ]???? ??? ?????? ?????? ??????? ?????? ????? ????? 50 0 1
  10 13????(??? ????????)? ??? ??????? ?????? ??? ? ?????? ?????? ?????????? ????? 77 0 1
  11 1??? ???? ?????????? ??????? ?????? ??????? ???? ????? 54 0 1
  12 2??? ?????? ??????? ?????? ??????? ???? ????? 45 0 1
  13 2??? ????1????? ?? ???? ????? ??????? ?????? ??????? ???? ????? 63 0 1

`

omidMolaverdi commented 4 years ago

hum, looks weird as it should be solved by adding charset="utf-8" to the <script> tag (<script XXXX charset="utf-8">).

Probably an issue with the query, do you set SET NAMES 'utf-8'in your query?

omidMolaverdi commented 4 years ago

Hi,

Is there any update on this thread?

QuintenJustus commented 2 years ago

Has been resolved.