March 31, 2004 at 12:12 pm
Hi all,
I wish to print special mathematical characters in my crystal report like the greater than equal sign ( ³ ). However, the char function just returns ascii codes between 0-255. This being a unicode (Hex) i am short of Ideas. Can anyone tell me, how do i save this symbol in a column in a table in sql server 2000? how will i be able to view this in crystal or MS access?
March 31, 2004 at 12:57 pm
I don't think you can unless you can find a font that is common to all machines that has it. Most people just use >= which is the same.
April 2, 2004 at 6:49 am
nchar(unicode)
select nchar(0x2265)
results: =
April 2, 2004 at 6:50 am
³
April 2, 2004 at 7:09 am
Here try this to pull from the KB articles for Crystal related to your question.
April 2, 2004 at 7:10 am
Thanks wz700. Where can i get a list of such unicodes to work with sql server?
April 2, 2004 at 7:12 am
Antares, that link did not work. Could you repost the link please? That would be helpful.
April 2, 2004 at 7:13 am
winword insert Symbols is one place
April 2, 2004 at 8:39 am
Sorry apparently they track requests to the KB section. Follow that link and in the search box type
crystal reports unicode characters
and press go then press to search with omitted results. That will give you what I was susggesting you look at.
April 2, 2004 at 8:51 am
Thanks Antares and WZ. Your feedback was very helpful.
May 4, 2004 at 1:43 pm
You can use the Character Map to copy a symbol and paste it into your CR Currency Symbol tab.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply