473,763 Members | 1,882 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to Store the Hindi Language in MySQL

4 New Member
when i insert the hindi data in mysql table it looks like ???????? format
how i can see the text in hindi langange.

pawej
Sep 10 '07 #1
2 9745
r035198x
13,262 MVP
when i insert the hindi data in mysql table it looks like ???????? format
how i can see the text in hindi langange.

pawej
Moved to MySQL forum
Sep 10 '07 #2
mwasif
802 Recognized Expert Contributor
For that you have to change the column character set and the connection character set to UTF-8.

After connecting to MySQL run the following commands
[PHP]mysql_query("SE T NAMES 'utf8'");[/PHP]
To display the Hindi characters in a HTML page, change the HTML content type to utf-8 as well using the following header
Expand|Select|Wrap|Line Numbers
  1. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
How you are inserting data to MySQL?
Sep 10 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
3140
by: kuldeep | last post by:
Hi all, I have developed a application that supports localization in .net. It shows all the controls with english and hindi text depending on the culture selected. The application runs well on windows 2000 and windows xp but when run on windows 98 the hindi text appears as garbage. Can anyone help out with this.(I have installed the .net framework on windows 98) Regards,
0
1932
by: kotianram | last post by:
hi, What are the changes needed in the resource file to support Hindi language using vc. I have converted the UI to CHinese and arabi etc .. Any suggestion on hindi . Regards Ramya
3
29727
by: pratik.best | last post by:
Hi, I just seen the web site of the unicode committee and was amazed to see the site showing document in Hindi without using any such fonts like "Kruti Dev" or "Dev Lys". "Webdunia.com" is also showing documents in Hindi without the need to download any specific font. How's that done? Also, can I build such a page?
0
1466
by: gauraw | last post by:
urgent, do any body know how to use hindi characters in c/c++ programm. i want to use hindi character in c language, how is it possible using normal turbo-c compiler(dos base). please directly respond me on my mail id **email removed**
0
1435
by: imranabdulaziz | last post by:
Dear All, I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2005 as a back End. My question Is it possible to generate report in hindi (language) format( using anything crystal report or report services of sql server) . Every thing will be in English(all master and transaction entry form in english) only thing i want to generate report language be in hindi. Please suggest me some idea or give me some...
6
4264
by: pawejpawej | last post by:
I want to store hindi language in the column of mysql table. what kind to changes can be done for that.
0
4300
by: villagegreen | last post by:
I'm trying to use an html form to upload foreign language translations of English terms into a MySQL database. Since many different languages will be entered on the page, I have read that I should set the charset on my uploading page as follows: <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> This has worked great for many different languages, including: Arabic, Spanish, Mandarin, etc. Basically, I have all the...
4
5183
by: pushpinderbagga | last post by:
hi I need help in storing and retreiving hindi text from myql... I have done the folowwing ... mysql_query("SET NAMES 'utf8'"); <META http-equiv=Content-Type content="text/html; charset=UTF-8">
2
4499
by: DR | last post by:
how to determine what language a c# string is written in? is there any C# method to take a string and return what language it is in? e.g. english, hindi, spanish, etc.
1
2167
by: DR | last post by:
how to determine what language a string is written in? is there any method to take a string and return what language it is in? e.g. english, hindi, spanish, etc.
0
9566
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10003
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9828
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8825
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7370
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6643
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5271
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3918
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3529
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.