Click here to Skip to main content
11,434,743 members (45,075 online)
Rate this: bad
good
Please Sign up or sign in to vote.
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 8:29am
Comments
Sergey Alexandrovich Kryukov at 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 at 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 at 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 at 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....
Member 8750537 at 3-Oct-12 15:53pm
   
Comment on my answer..
Sergey Alexandrovich Kryukov at 3-Oct-12 16:00pm
   
Excuse me, which answer?
--SA
Member 8750537 at 3-Oct-12 16:06pm
   
The lastest answer that starts with "Thank you for amazing prob.."
Sergey Alexandrovich Kryukov at 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 at 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
Member 8750537 at 3-Oct-12 16:10pm
   
@Sergey.. yeah it was bcoz of my mistake.
Rate this: bad
good
Please Sign up or sign in to vote.

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. Smile | :)

HINDI TEXT

Does it solve your problem?
Please reply.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

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....
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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

—SA
  Permalink  

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



Advertise | Privacy | Mobile
Web01 | 2.8.150428.2 | Last Updated 4 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100