Hello all,
Hindi data could be dealt using 'utf8' encoding. Only issue arises is because of display problem in MySql querry browsers. So here is a series of solution to avoid that.
1) write the output into any text file, for example
select * into outfile "YOUR TEXT FILE PATH/FILE_NAME.txt" from table_name;
2) OR we can redirect this output to any browser.(since browsers support utf8.
3) OR any other editor/browser/application which supports utf8.
4) OR we can spool all the activities and output into any text file for example
spool "YOUR TEXT FILE PATH/FILE_NAME.txt"
spool off; // whenever you don't want to show output into text.
NOTE: spool command will log every activity of yours at querry browser. including querries you provide, error output , correct output or anything else.( I suggest better way is to go with "into outfile" method).
Also
Here i am mentioning all the necessary steps to follow in order to deal with Hindi Data(Devanagiri Script) Or infact any script which could be encoded as UTF8.
1) give the following in command line querry browser .
SET NAMES 'utf8';
2) then create any database , use database and then create tables in the following manner
example:
create database स्टुडेन्ट character set 'utf8';
use स्टुडेन्ट;
create table नाम_सूची(ID int,fname char(20),lname char(20)) character set 'utf8';
3) Now you can perform any operation on this table/database which includes any hindi text.
example: insert into नाम_सूची values(001,'महिपाल','सिंह');
It will perfectly perform the queries and output you can see in a text file by the above mentioned method.
Moreover we can provide our database names,table names as well as column names in HINDI. all you need to do is follow the above steps.
Any querry/issue regarding this is most welcomed.
Mahipal Singh Rathore,
Student, M.Tech.(IT),
International Institute of Information Technology,
Bangalore(IIITB).
Email:
mahipalsingh.rathore@iiitb.net