how to insert hindi data in mysql from excel file in php

Question

0.00/5 (No votes)

See more:

i want to import hindi text excel file in mysql database. but when i import excel file in mysql using php script hindi characters are change in english chars and stored in db.
so plz help me how to insert hindi text in database using excel file

Posted 6-Jan-15 4:51am

Member 11356307

Add a Solution

Comments

Zoltán Zörgő 6-Jan-15 11:03am

1) Do you have xls or xlsx?
2) What library do you use to read those files?
3) Do you use utf-8 allaround your application sources?
4) If you print the text before inserting into db, what do you see?
5) What character set you have used when creating the database?
6) Which library do you use to connect to the database?
7) How do you set up your connection to the database in PHP?

Member 11356307 6-Jan-15 12:08pm

i have xlsx file
i use PHPExcel library to read excel file
ya i use utf-8 char set
i print the text before inserting db is "i`Foh ds vkUrfjd"
i use utf8_unicode_ci character set for db table
i use codeigniter databse connection api

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2015-01-06T08:04:00

Solution 1

1) Set up Codeigniter for UTF-8 properly: https://philsturgeon.uk/blog/2009/08/UTF-8-support-for-CodeIgniter/[^]
2) Check if the xml in the xlsx file is utf8. You might need to convert encoding with iconv or mb. You can also try detecting the encoding read with mb_detect_encoding[^]

Posted 6-Jan-15 8:04am

Zoltán Zörgő

Comments

Member 11356307 6-Jan-15 15:47pm

i do every thing as you describe above but i have same problem. i still have output like i`Foh ds vkUrfjd Hkkx esa rki?e forj.k ls lacaf/kr lR; dFku g instead of पृथ्वी के आन्तरिक भाग में तापक्रम वितरण सि संबंधित सत्य कथन है

Zoltán Zörgő 6-Jan-15 15:56pm

Sorry. If you really did, than i have no future idea without seeing it :(