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

Expand Post »

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

mahakaal

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jul 2009

Permalink

Nov 8th, 2009

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

Hey.

HTML:

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

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.

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Permalink

Nov 9th, 2009

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

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

Click to Expand / Collapse Quote originally posted by Atli ...

Hey.

HTML:
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
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.

venkat0904

Reputation Points: 13

Solved Threads: 21

Junior Poster

Offline

186 posts
since Oct 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Forget Password in PHP

Next Thread in PHP Forum Timeline: require() all files in a directory structure

DaniWeb Message

Cancel Changes

User Name
Password