Linked Questions
31 questions linked to/from strange character encoding of stored data , old script is showing them fine new one doesn't
2
votes
1
answer
2k
views
How to convert non-readable utf8 chars in MySQL to readable [duplicate]
I have Arabic text stored in mysql like this format
شقق جديده غبر مسكونه 220 متر..
.150متر..طبربور ..ااسكانات قموم
والنجار للاستÙسار
it is ...
- 650
2
votes
0
answers
1k
views
How to convert characters into hindi characters in PHP [duplicate]
I am trying to convert database column that is stored in utf8_unicode_ci collation to hindi characters.
For example:
दà¥à¤ƒà¤– का अधिकार- Quiz 1
This is not showing in hindi ...
- 151
0
votes
1
answer
1k
views
MySQL data has wrong encoding when displaying using PHP [duplicate]
I am absolutely stuck.
I have an old website that was running on PHP4 and MySQL4. The SQL data contains slovak special characters (á, š, ť, ľ, ž etc.). The old site displays the characters fine.
I'...
- 865
1
vote
0
answers
708
views
How to convert UTF8 encoding to simplified Chinese [duplicate]
I was using PDO MySQL to insert data from PHP. What I didn't know, I had to use "SET NAMES 'utf8'" statement before making every query.
So all the input made in Simplified Chinese before making that ...
0
votes
0
answers
491
views
PHP utf8_decode some characters decode correctly some not [duplicate]
Okay, something went wrong in our database and now all the content from Chinese, Turkish etc. language is messed up (wrong characters). I'm trying to create a PHP script to convert it. Yes, SET NAMES ...
- 2,378
0
votes
0
answers
406
views
SET NAMES or setEncoding utf8 in RedBeanPHP? [duplicate]
I am using REDBEANPHP 3.5 | easy ORM for PHP and working with me for all parts in my app but now I have a problem while select data from database with Arabic content via
R::setup('mysql:host=' . ...
- 3,315
0
votes
2
answers
538
views
UTF-8 to HTML Character Decimal Codes before use inside code or importing in sql [duplicate]
how can i detect and convert below strings to readable string this strings?
سئوالات
مطاعن ابوبكر
مطاعن عمر
since these strings with UTF-8 in MySQL database and our language ...
- 17.6k
0
votes
0
answers
225
views
Mysql, Apache, PHP UTF encoding issues [duplicate]
I'm trying to move a site and I'm really baffled with the problems I'm having trying to sort out the encoding issues with the database.
The database on new server is using utf8 and all tables ...
user7473070
0
votes
0
answers
166
views
Converting UTF8 data to latin1 in mysql [duplicate]
I have a mysql table with 70K+ data which is utf8 encoded.
The data looks good on browser but on sql tools it looks like gibberish पवठ. Therefore I decided to convert this table data into ...
- 193
0
votes
0
answers
158
views
utf-8 charset with PDO [duplicate]
Im trying to display some Indian language characters (Hindi, Tamil, etc) in a php file, taking the data from a MYSQL database.
It works fine with mysqli_query, but with PDO, the characters show up as ...
- 2,139
0
votes
0
answers
133
views
Problem getting charset working when moving database [duplicate]
Short. I am moving a database and webpage. It is now an exact copy but on the webpage it doesnt display the swedish characters correctly.
Example
VÃƑ„RMARE should be VÄRMARE
In the old database it is ...
0
votes
0
answers
111
views
import MySQL 5.7 MyISAM to MySQL8 InnoDB £ no longer displaying [duplicate]
I have recently imported a mysql 5.7 database to mysql8 a table which was myisam in mysql 5.7 is now Innodb in mysql8 any content which contains a £ either doesn't display at all and I mean not just ...
- 442
0
votes
0
answers
53
views
MySQL migration issues with UTF8 [duplicate]
We are currently migrating a legacy application from an old server to a new server. We're running into an issue where utf-8 encoded data was stored in a latin1 table.
On our old server, we had PHP 5....
- 10.2k
0
votes
1
answer
42
views
Same php scripts, same mysql db, different displays or accented characters [duplicate]
I just copied a website to a new server (files + db) then I have the exact same php scripts and the exact same db.
I have that table :
CREATE TABLE `cours` (
`idcours` int(11) NOT NULL,
`...
- 2,271
0
votes
1
answer
31
views
DB with wrong character encoding [duplicate]
I have ended up with a DB possibly with wrong encoding.
For example there is a row that contains
profiles – Craftsman
Is there any way to convert this back to what ever it supposed to be?
I think ...
- 1,704