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

[Mayur P Vegad]

hi mahipal sinh ,



show variables like 'character%';


'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'latin1'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'latin1'
'character_set_system', 'utf8'
'character_sets_dir', 'C:\Program Files\MySQL\MySQL Server 5.1\share\charsets\'

-- which character set and collation setting are required ?
like for japaness,chinese , german character values in my db table are not insert so please give solution to store these multi langauge data in db.