how to convert data which comes from database in hindi and export to excel file that name in hindi or english

Question

0.00/5 (No votes)

See more:

i have a db in which name of customer name is stored in hindi. now i want fetch that customer name and export to excel file that name.

when i fetch the data and export to excel file name converted saome other non readable lauguage like: `$5`$>`$& `$8`$. 27/08 `$.`%0 `$*`% `$0`%`$.`$?`$/`$0 `$.`%`$!`%`$`$2 `$8`$?`$8`% b `$`$. `$

Posted 15-Sep-13 20:32pm

rupal from india

Add a Solution

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-09-15T21:08:00

Solution 1

There is no difference, English or Hindi (Devanagari, actually). You only need to use Unicode everywhere. Devanagari is supported on nearly all modern systems by default. With SQL, you need to use Unicode data types. Please see: http://technet.microsoft.com/en-us/library/ms191200%28v=sql.105%29.aspx[^].

—SA

Posted 15-Sep-13 21:08pm

Sergey Alexandrovich Kryukov

Comments

rupal from india 16-Sep-13 4:12am

i don't understand the solution can u please elaborte it.......or give some example to solve the problem

Sergey Alexandrovich Kryukov 16-Sep-13 4:16am

What part of it you don't understand?
Do you know what Unicode is? Do you know that PHP supports Unicode? Do you know how to setup database columns and their data types?
—SA

rupal from india 16-Sep-13 4:48am

actually i got a code nd nw have to work on that m doing first time on such type of thing...........so its become difficult for me to work on that...........let me tell you my db table filed my field is cusname with collation latin1-swedish-ci type varchar

Sergey Alexandrovich Kryukov 16-Sep-13 9:01am

Okay, very good. I cannot see your code to find out what else could be wrong. You need to make sure that you use only Unicode in all steps.
—SA