DaniWeb Forum Index > Web Development > PHP

how can i make a web page having both english and hindi character with php mysql

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2009

Posts: 5

Reputation: mahakaal is an unknown quantity at this point

Solved Threads: 0

mahakaal

Offline

Newbie Poster

how can i make a web page having both english and hindi character with php mysql

21 Days Ago

How to handle UTF-8 characters in HTML, JavaScript, PHP and MySQL ...

•

Join Date: May 2007

Posts: 432

Reputation: Atli is on a distinguished road

Solved Threads: 56

Atli

Offline

Posting Pro in Training

21 Days Ago

Hey.

HTML:

 Help with Code Tags 
 html Syntax (Toggle Plain Text) 
<!DOCTYPE html>
<html>
    <head>
      <meta http-equiv="content-type" content="text/html; charset=utf8">
    </head>
    <body />
</html>
<!DOCTYPE html>
<html>
    <head>
      <meta http-equiv="content-type" content="text/html; charset=utf8">
    </head>
    <body />
</html>

MySQL

 Help with Code Tags 
 mysql Syntax (Toggle Plain Text) 
-- When creating a table:
CREATE TABLE `myTable`(
  -- <insert fields>
)DEFAULT CHARSET=utf8;
 
-- Before querying the database.
-- Note, this is usually not needed, but can be.
SET NAMES 'utf8';
-- When creating a table:
CREATE TABLE `myTable`(
  -- <insert fields>
)DEFAULT CHARSET=utf8;

-- Before querying the database.
-- Note, this is usually not needed, but can be.
SET NAMES 'utf8';

And as to PHP and Javascript...
You usually don't have to worry much about the character encoding in either of those. Just make sure you create the code files themselves as UTF-8 (without BOM) and you should be fine.
PHP strings are basically just byte arrays, so they don't differentiate between charsets, unless you attempt to manipulate them using the string functions, in which case they are treated as ISO. (Unless the function offers the ability to specify a charset.)

However, if PHP is giving you trouble, you can use utf8_encode to convert ISO characters over to UTF-8.
Also, if you use htmlentities or htmlspecialchars, make sure you set the third parameter correctly.

Please do not ask for help in a PM. Use the forums.
And use [code] tags!

•

Join Date: Oct 2009

Posts: 151

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 15

venkat0904 venkat0904 is offline

Offline

Junior Poster

21 Days Ago

nice info Atli... i guess it will prove helpful fr me someday

•

Originally Posted by Atli

Hey.

HTML:
Help with Code Tags

html Syntax (Toggle Plain Text)
<!DOCTYPE html>
<html>
    <head>
      <meta http-equiv="content-type" content="text/html; charset=utf8">
    </head>
    <body />
</html>
<!DOCTYPE html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf8"> </head> <body /> </html>
MySQL
Help with Code Tags

mysql Syntax (Toggle Plain Text)
-- When creating a table:
CREATE TABLE `myTable`(
  -- <insert fields>
)DEFAULT CHARSET=utf8;
 
-- Before querying the database.
-- Note, this is usually not needed, but can be.
SET NAMES 'utf8';
-- When creating a table: CREATE TABLE `myTable`( -- <insert fields> )DEFAULT CHARSET=utf8; -- Before querying the database. -- Note, this is usually not needed, but can be. SET NAMES 'utf8';
And as to PHP and Javascript...
You usually don't have to worry much about the character encoding in either of those. Just make sure you create the code files themselves as UTF-8 (without BOM) and you should be fine.
PHP strings are basically just byte arrays, so they don't differentiate between charsets, unless you attempt to manipulate them using the string functions, in which case they are treated as ISO. (Unless the function offers the ability to specify a charset.)

However, if PHP is giving you trouble, you can use utf8_encode to convert ISO characters over to UTF-8.
Also, if you use htmlentities or htmlspecialchars, make sure you set the third parameter correctly.

Gimme reputation points if u find my post helpful.
use [code] tags wherever applicable
dont start a new thread unless u cant find the topic already on forum.
mark a thread "solved" as soon as u get a solution