1

I tried so much to find the solution for this problem, I think the problem on phpmyadmin itself. I set true collaction value "utf8_general_ci" and tried also "utf16_general_ci". configure mysql character system set also, but the problem is still.

FYI, when I retrieve the data from the table using php code the data would be on arabic and intact, but from phpmyadmin there was rubbish like :اسمه رقمه استاذ مساعØ"

Aladdin
  • 1,207
  • 2
  • 16
  • 26
  • 1
    Is the data in the database stored as UTF-8 or as win-1256? – Tarik Feb 24 '15 at 09:24
  • I dunno why OP's being downvoted, this is a legit question. – Andrei P. Feb 24 '15 at 09:24
  • This is a legit question indeed. Downvoters please explain. – Tarik Feb 24 '15 at 09:27
  • I think that what @Tarik is asking is, which locale did you use when you filled the database in? This is usually accomplished with a `SET NAMES` query. – didierc Feb 24 '15 at 09:45
  • @Tarik is stored as UTF-8. – Aladdin Feb 24 '15 at 11:07
  • Have you seen http://stackoverflow.com/a/4779380/2385479 and http://stackoverflow.com/a/26436561/2385479 and http://stackoverflow.com/a/21279793/2385479 and https://wiki.phpmyadmin.net/pma/Garbled_data ? Which phpMyAdmin version are you using? Can you show some code about when you set up the database connection? – Isaac Bennetch Feb 27 '15 at 03:02

0 Answers0