April 30, 2012 at 2:32 am
Hi
I am ablt to store the new indian rupee symbol '₹'(it's becoming a box here. so pls see this link on how it actually looks:
in a table having an nvarchar column in sql server 2008 R2 (SP1).
But I am not able to retrieve it with below code:
declare @cr nvarchar(20)
set @cr=N'₹'
select nchar(unicode(@cr))
I get back a box in return.
This new sybol was incorporated by unicode org. in 2010 in version 6.0. So it should have all unicode support. And I don't think I need to install additional software for it's support in sql server 2008 R2.
Can someone guide?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
May 1, 2012 at 7:54 am
For anyone facing same issue, here is how the discussion went:
http://social.msdn.microsoft.com/Forums/en/transactsql/thread/8fb014a7-4505-48c2-9f8c-d35fcd73b208
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
May 1, 2012 at 8:38 am
It's storing the character, but SSMS doesn't display it. What front-end will the actual application use, and does that front-end support a font that displays the symbol?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 1, 2012 at 8:48 am
The from end will be a SSRS report(2008 R2). And I think it should be supporting the font if sql server 2008 R2 is supporting it. As I mentioned in the MSDN post, if i retrieve the symbol in text(ctrl+T), I get it back. So it is supported, right?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
May 1, 2012 at 9:07 am
S_Kumar_S (5/1/2012)
The from end will be a SSRS report(2008 R2). And I think it should be supporting the font if sql server 2008 R2 is supporting it. As I mentioned in the MSDN post, if i retrieve the symbol in text(ctrl+T), I get it back. So it is supported, right?
from following the discussion it is supported. if the unicode character is in the font set it will display the character if not the font set says "Dont know what to show here so ill show a box." so even though you see a box on the text out put its because the font currently in use cant find a character. its like trying to convert the japanese kanji to an english font, the unicode data is still there but its up to the front end to have the right picture to show with the unicode data.
the only way to know for sure is to write the report and if the rupee symbol does not show correctly you will have to play with the font of the report a little to get one where it will show.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
May 2, 2012 at 6:23 am
S_Kumar_S (5/1/2012)
The from end will be a SSRS report(2008 R2). And I think it should be supporting the font if sql server 2008 R2 is supporting it. As I mentioned in the MSDN post, if i retrieve the symbol in text(ctrl+T), I get it back. So it is supported, right?
Yes. All you have to do is make sure the report is using a font that displays that character.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply