Russian Language in PHP HTML

Question

I saved Russian Language in PHP & MySql. Here is sample characters тыуиппюлкйчг

I used these lines in PHP while saving

mysql_query("set character_set_server='utf8'");
mysql_query("set names 'utf8'");

I checked in Database it saved sucessfully..Now i want to display it to user in EDITOR,It return me ????????????

Here is my code how i am getting from table and display it

$.getJSON("getSingleRow.php?id="+id+"&type="+type, function(json){ 
 $("#"+key).val(val);
});

And on getSingleRow.php i have this code

echo json_encode($russian);

Note: when i run getSingleRow.php directly,it also prints ????????????

UPDATED: First of all,It saved sucessfully in database,i can see there is in russian language.

I have two pages to get it.One page having editor,I have this line on top

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

Also on top in php i have this line

header('Content-Type: text/html;charset=utf-8');

Other file is on server side from where i get it...getSingleRow.php On top of this page i have

header('Content-Type: text/html;charset=utf-8');

and on end i have this code

echo json_encode($russian);

All answers given to this question has been applied already but no luck

EVEN simple this code is not working

<?php
header('Content-Type: text/html;charset=utf-8');
echo "тыуиппюлкйчг ";
?>

If you print your database get output...is it working correctly? I had some trouble by getting from the database. — eL-Prova, May 06 '14 at 08:22
See my updated answer. mysql_query("SET NAMES UTF8"); is wrong for you I think :-) — eL-Prova, May 06 '14 at 08:27
I saved sucessfully in database..only issue is in viewing...and yes i applied all your suggestions but not working — user3244721, May 06 '14 at 08:32
When you do a select in your query via phpmyadmin or something, correct output? Have you checked by setting the php file to UTf-8 can work? — eL-Prova, May 06 '14 at 08:34

score 2 · Answer 1 · answered May 06 '14 at 08:01

2

Put a header charset=utf-8 in the page where you want to display it.

<?
header('Content-Type: text/html;charset=utf-8');
?>

answered May 06 '14 at 08:01

please see updated question...I already have this line...but not working – user3244721 May 06 '14 at 08:11

score 1 · Answer 2 · edited May 23 '17 at 12:05

1

Make sure the database charset/collation is UTF-8
On the page you insert these russian characters ( the form, textarea ), make sure the encoding is UTF-8, by setting Content-Type to text/html; charset=utf-8. Enter in russian text directly to the form input.
On the processing page that handles this form, which inserts it into the database, make sure to do SET NAMES utf8 so it's stored as UTF-8 before you insert the data, in a separate query beforehand.
When you render the content from the database in a view, make sure the Content-Type is text/html; charset=utf-8.

Make sure that the content-type is not windows-1251 or iso-8859-1/latin1. Make sure the database charset/collation is NOT ISO-8859-1/Latin1.

From: MySQL - Russian characters display incorectly

edited May 23 '17 at 12:05

Community

1
1

answered May 06 '14 at 08:01

eL-Prova

1,084
11
27

For russian or russian-english website utf8_general_ci collation is usually used. If languages with special latin characters are to be used (such as german), utf8_unicode_ci is needed. – Mikhail Batcer May 06 '14 at 08:05
I saved sucessfully in database...i can see there...But when i want to get it back it give me ????? please see my updated question – user3244721 May 06 '14 at 08:12

score 0 · Answer 3 · answered May 06 '14 at 08:00

The collation on the database must be set to cyrillic to accept the Russian characters. I ended up using the CYRILLIC_GENERAL_CI_AS collation set.

Check this link : http://www.davecheung.com/blogpost/converting-a-sql-server-2005-database-to-accept-russian-charactersmultilingual-characters/

Kakitori · Answer 4 · 2014-05-06T08:20:34.937

0

Have you tried JSON_UNESCAPED_UNICODE parameter inside the json_encode() ?

json_encode($russian, JSON_UNESCAPED_UNICODE)

Just works in PHP 5.4.0

If your version is previous try this:

<?php
$str = 'russian - русский';
$str = json_encode($str);
$str = preg_replace_callback('/\\\\u([0-9a-f]{4})/i',
function ($matches) {
    $sym = mb_convert_encoding(
            pack('H*', $matches[1]), 
            'UTF-8', 
            'UTF-16'
            );
    return $sym;
},
$str
);
echo $str . PHP_EOL;

edited May 06 '14 at 08:20

answered May 06 '14 at 08:14

Kakitori

901
6
16
41

Warning: json_encode() expects exactly 1 parameter, 2 given in – user3244721 May 06 '14 at 08:17

score 0 · Answer 5 · answered Oct 26 '18 at 07:05

0

Please set mysql_set_charset('utf8'); Above Where you displaying the data.

answered Oct 26 '18 at 07:05

Stephen

69
2
10

score 0 · Answer 6 · edited Jan 05 '19 at 12:51

0

After using this code

$conn = mysqli_connect($dbhost, $dbuser, $dbpass);

you have to add this code for Russian language in MySQL.

mysqli_query($conn, "set names utf8");

edited Jan 05 '19 at 12:51

Mark Ormesher

2,289
3
27
35

answered Jan 05 '19 at 07:34

Clarenceli

31
5

Russian Language in PHP HTML

6 Answers6