Click here to Skip to main content
12,394,573 members (82,032 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-server-2005 SQL-Server , +
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
Comments
   
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.
   
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....
Member 8750537 3-Oct-12 15:53pm
   
Comment on my answer..
   
Excuse me, which answer?
--SA
Member 8750537 3-Oct-12 16:06pm
   
The lastest answer that starts with "Thank you for amazing prob.."
   
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
   
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 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 4 Oct 2012
Copyright © CodeProject, 1999-2016
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