Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PHP, MySQL and International language support

Status
Not open for further replies.
johnsmith180

johnsmith180

Programmer
Oct 26, 2005
27
GB
Hi

Currently, I am testing how to create an Arabic website with PHP and MySQL 4.1

I have set the collation of the database , table and column to "cp1256_general_ci"

Now I have this PHP code:

<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("ArabicTest", $con);

$result = mysql_query("SELECT * FROM Arabic where BINARY t1='????'") or die(mysql_error());

while($row = mysql_fetch_array($result))
{
echo $row['t1'];
echo "<br />";
}
?>

However, I am getting following text: "????". Please advise me how I can display the arabic text on the web page.

(If I run "SELECT * FROM Arabic where t1='????' " in phpmyAdmin, I can get the arabic text.)

Kind regards
 
Sort by date Sort by votes
try sending a unicode header before outputting ANY content

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

you could also/instead set the default charset in php.ini



 
Upvote 0 Downvote
Thanks jpadie

I have tried
header('Content-Type: text/html; charset=utf-8'); or
header('Content-Type: text/html; charset=cp1256');

However, I still have the same problem.

Actually, one of the table rows contains the following characters (see the charcters in Red marker:

Now when this data is displayed on the webpage, the Arabic characters are being displayed correctly.

But for table rows that contains the actual Arabic characters: ????, I get ????

So I am not sure how to solve this. Hope someone will have a solution.

regards
 
Upvote 0 Downvote
try adding this to the page in the <head> tags (as well as the header directive)

Code: 
<meta http-equiv='Content-Type' content='text/html; charset=cp1256' >

are you getting the same behaviour in IE and Firefox?
 
Upvote 0 Downvote
The following does not have any effect:
<meta http-equiv='Content-Type' content='text/html; charset=cp1256' >

I am getting the same behaviour in IE and Firefox

Thanks
 
Upvote 0 Downvote
can you post the code you are using to retrieve the data from the database and display it?
 
Upvote 0 Downvote
I have found the solution.

I need to set the character set for the MySQL connection, otherwise, mysql will not return arabic characters. So use the following after database connection has been setup:

mysql_query("SET CHARACTER SET cp1256", $con);

regards
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
import CSV file into MySql table in PhpMyAdmin
Replies
0
Views
250
SashaBuilder3
SashaBuilder3
lexer
  • Locked
  • Question
Join two mysql tables for populate datatable
Replies
3
Views
202
spamjim
spamjim
PeDa
  • Locked
  • Question
Unwanted spaces in php HTML mail 1
Replies
4
Views
232
PeDa
PeDa
ersatz
  • Locked
  • Question
How to send 2 select from mysql database in email like tables
Replies
5
Views
306
ersatz
ersatz
Mandy_crw
  • Locked
  • Question
How to send sms in PHP using usb gsm modem?
Replies
1
Views
241
vishvajit
vishvajit

Part and Inventory Search

Sponsor

Back
Top