Re: Way to Create , Store , Retrieve & Perform Operations on Hindi Data

[mahipal rathore]

Hey mayur,
actually for dealing with any script in your database . you need to follow only these

'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'utf8'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'utf8'
also once type out
set names 'utf8'
just after entering into any database ( i.e. after use database dbname) ;

If your database in such a way that multiple tables are dealing with different different script characters or within same table multiple columns dealing with different scripts then you need to define those columns and tables while creating .
say for example
create table mayur(int id,name varchar(20)) character set 'utf8';
same way you can define this for individual columns (by declaring this after any partiular column)

Ifyou wanna deal with any other script in specific which is not able to deal in utf8 then define your collation schema and charset files , put them into the specified folders. (detail is given in mysql documentation and manual)

then use following
set character set 'latin' collation schema 'latin-derive';