European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: How Indian(Hindi) Language store in mysql
By: pawej	Date: 12/09/2007 13:29:10	Points: 20	Status: Answered Quality : Excellent
I want to store the Hindi language (Indian Reginal language) what kind of changes I have to make. I set these; set character_set_connection=utf8; set collation_connection=utf8_unicode_ci; set names utf8; but when we insert the hindi text into the column its appers like ??????? format. Please help me. pawej
By: VGR	Date: 13/09/2007 07:40:41		Type : Comment
hello, the problem may lie in the way you input the data. The problem is not Hindi itself. Let me take this example of an accentuated character in ISO 8859-1 : é (e acute) if I use a front-end (PHP) to introduce it in a latin-1 charset mysql database, I can read it back correctly in the displayed HTML, read via PHP. BUT if I read directly the data from the mysql console, I see '?' or a fancy non-printable character. The reverse is true : if I introduce directly 'é' at the mysql console level, I read back '?' in PHP but I still see 'é' in the data. That's normal IMHO. It must have to do with Windows' ANSI, WIN-1252, UTF support etc Just use the same way to introduce the Hindi characters as when reading them.

By: pawej	Date: 13/09/2007 08:49:28		Type : Comment
I use JSP as a front-end.But I want to read the data directly from the mysql, I set the character UTF8 but it show's like ??????. Help

By: VGR	Date: 13/09/2007 19:04:14		Type : Answer
then it's normal. Your browser (reading the JSP-generated pages) isn't configured correctly. Are you sure ("tools"/"Page Info" in firefox) that the encoding, charset etc are correct for the page ? also, UTF8 is a pain in the neck. If you want to "use JSp as a front-end" (sic), then read your data through JSP pages, and write them the same. Don't expect the mysql console to display data the same way. Or soed hours tweaking the charset and the DB engine so that it spits finally your ccentuated charcaters. I suggest that you check this first (in MySql console) : show variables; then look at this section (on top of the list) - that's mine - \| character_set_client \| latin1 \| character_set_connection \| latin1 \| character_set_database \| latin1 \| character_set_filesystem \| binary \| character_set_results \| latin1 \| character_set_server \| latin1 \| character_set_system \| utf8 \| character_sets_dir \| D:\MySQL\share\charsets\ \| collation_connection \| latin1_swedish_ci \| collation_database \| latin1_swedish_ci \| collation_server \| latin1_swedish_ci

By: VGR	Date: 13/09/2007 19:07:36		Type : Comment
two documents : http://www.thescripts.com/forum/thread584624.html http://forums.mysql.com/read.php?103,86499,86910#msg-86910

By: VGR	Date: 27/03/2008 22:20:18		Type : Comment
ok ?

By: VGR	Date: 02/07/2008 08:09:02		Type : Comment
ok ? If no more feedback, then close the Question...

Do register to be able to answer

Add This Article To:
Del.icio.us	Digg	Google	Spurl
Blink	Wong	Simpy	Y! MyWeb

Contact

page generated in 4691.725020 milliseconds

Why Google AdSense ads ?