print value in hindi font in crystal report

Question

3.00/5 (2 votes)

See more:

SQL-Server-2005

, +

I want to print the value of my table's field in hindi font. i was insert it in hindi font using unicode means like this
INSERT INTO VALUES (N' fields name ')
so that the value inserted as it is how i was typed but now i want to use crystal report to print some values from my table. please some one can help me about this problem.
thank you..

Posted 3-Oct-12 7:29am

tanisha pandey

Add a Solution

Comments

Sergey Alexandrovich Kryukov 3-Oct-12 14:05pm

There is no such thing as "Hindi font". I'm tired to explain it. And, a disclaimer for those who will tell me: "this is a Hindi font": wrong; it may be called this way, but then the name is wrong. 1) This is not how Unicode works: normally, a font supports many writing systems at once; 2) Hindi is only one of languages using Devanagari.

Tanisha, you are a software development, and you are from India. I think you should know more about the culture of your own country. It deserves much more respect, in my opinion.
--SA

P.S.: also, Devanagari is so popular in the worlds that nearly all modern systems support it by default. I never installed anything specific to it, but Devanagari was always available to me on all Windows, Linux and Mac OS X systems I tried. You should have screw up things really well to loose this default support.

tanisha pandey 3-Oct-12 14:32pm

Can you tell me if I want to Print value through my table Id using crystal report even if Values are picture or any type of data. If datatype of my tables field is nvarchar.

Sergey Alexandrovich Kryukov 3-Oct-12 15:59pm

Well, for nchar, nvarchar, ntext are the types to support Unicode. That's all you need. You could somehow loose Unicode between the SQL server and application, I don't know how. Please also see the link in my answer.
--SA

tanisha pandey 4-Oct-12 1:48am

Thank u for that solution but i have a problem to access that unicode in crystal report from sql server tables. i have already solved the problem to insert unicode in sql and access in my windows application but not in crystal report. so i just want to access that values in my crystal report and that unicode value is nothing but in hindi laguage. If any solution for this problem then please suggest me. and if there is no solution then inform me.
thank you SA....

mohitjain012 3-Oct-12 15:53pm

Comment on my answer..

Sergey Alexandrovich Kryukov 3-Oct-12 16:00pm

Excuse me, which answer?
--SA

mohitjain012 3-Oct-12 16:06pm

The lastest answer that starts with "Thank you for amazing prob.."

Sergey Alexandrovich Kryukov 3-Oct-12 16:08pm

Please, to avoid confusions, reply exactly to the post you are replying to. You are commenting the question right now.
How about a link?
--SA

Sergey Alexandrovich Kryukov 3-Oct-12 16:09pm

I see, this must be Solution 4. Right? Believe or not, this solution was not published when you commented, by some reason.
--SA

mohitjain012 3-Oct-12 16:10pm

@Sergey.. yeah it was bcoz of my mistake.

3 solutions

Solution 4

Thank you for amazing problem.
I searched a lot on net for this.
Finally i am very closed to solve your problem.

For setting data in hindi we should use utf8 character set and collation with utf8_general_ci

CREATE TABLE hindi5(hindi VARCHAR(100)) CHARACTER SET utf8 COLLATE utf8_general_ci;

Now i cannot insert the hindi written in text file in mysql command line.
insert into hindi5 values(HINDI TEXT);

But it was showing question mark(?). So i use java netbeans and connected database to it. Then i inserted row using java. Then i give select * command from command line, but it was showing very different code, i thing bcoz hindi is not support in command line.
Then to display that inserted text i use java netbeans again and select command and got the same text as was inserted. :)

HINDI TEXT

Does it solve your problem?
Please reply.

Posted 3-Oct-12 10:03am

mohitjain012

Solution 3

Please see my comments to the question. See also:
http://stackoverflow.com/questions/10965589/unicode-data-type-in-sql[^].

—SA

Posted 3-Oct-12 10:00am

Sergey Alexandrovich Kryukov

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)

tanisha pandey · Accepted Answer · 2012-10-03T21:59:00

Solution 5

It is so simple to change font in hindi. i just change it's format to mangla font then it will show me my desire result. some times we don't know what is the problem and there solution. sorry to all for asking this stupid question. hope you all don't mind.
and thank you....

Posted 3-Oct-12 21:59pm

tanisha pandey