How to store gujarati data into mysql server?

I want to execute one functionality in which i have to upload an excel sheet having data in gujarati font and after uploading i have to store that data into mysql database.

Now here i have to use two languages for displaying output - one is english and one is gujarati.

Somewhere i have to display mysql db data in english and somewhere in gujarati.

Now i need suggestion that how could i implement such functionality?

Should i change mysql server locale to gujarati or should i keep the mysql server in english locale and convert the data from gujarati to eng or eng to gujarati at frontend.

Please suggest something.

Solution

You should Change the field's collation to utf8_bin so that MySQL will stores the data in gujarati and in english properly.

Will modifying the primary key type using ALTER in MySQL reset the auto-increment value to 0?
Auto-increment is not resetting in MySQL
Php update database if checkbox is not checked
Retrieve 10 records from MySQL?
how to use str_to_date (MySQL) to parse two-digit year correctly
sum column value(s) if previous values has same value with current value from the same table in mysql
JDBC connection without database definition
Checking connection to MySQL (Java)
WARN: Establishing SSL connection without server's identity verification is not recommended
how to solve django.db.utils.NotSupportedError in django
How to make an Inner Join in django?
Can I order by a conditional combination of fields in MySQL?
Select from 2 tables in the last 30 days, return 0 if null/not exist
Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)
Access denied for user 'root@localhost' (using password:NO)
Watching a table for change in MySQL?
table is specified twice both as a target for INSERT and as separate source of data
Python Mysql, "commands out of sync; you can't run this command now"
Does Laravel's "soft_delete" need index on MySQL?
How do I access a field from the main query inside a sub query in mySQL?
Not getting unpaid or partially paid records some can help me?
Warning: The post-install step did not complete successfully when trying to install mysql using brew in Mac OS High Sierra
MySQL Entity Attribute Value table structure proposal
CodeIgniter SELECT query on table with JOIN and WHERE IN a subquery
is there a MYSQL tables schema for storing raw material, intermediate and final products?
MySQL: Total GROUP BY WITH ROLLUP curiosity
Problem with pip install mariadb - mariadb_config not found
nodejs mysql memory leak on large volume of high frequency queries
`MODIFY COLUMN` vs `CHANGE COLUMN`
Displaying BLOB image from Mysql database into dynamic div in html