• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1871
  • Last Modified:

How to store math symbols and text in sql server 2005?

I have an app that reads a text file containing course objectives and stores in SQL db.  When the asp.net 2.0 app reads the word file and converts to .txt.  The math symbols are lost.  This is bad but not tragic if I could update the db by editing the particular objective and inserting the math symbol.

How does one store math symbols along with text?
0
vstack
Asked:
vstack
  • 2
  • 2
3 Solutions
 
momi_sabagCommented:
if you use unicode data types (nvarchar) than you could store any symbol you want
you could also load the file directly into sql server and not going through the asp code at all and this way the symbols won't be lost
0
 
QlemoC++ DeveloperCommented:
You are limited to symbols included in a charset. There are many, e.g. greek letters like sigma. If you need more complex things you will have to store PDF, DOC or whatever directly as LOB (binary object type).
0
 
vstackAuthor Commented:
I hear you.  What we are trying to do is store the objectives so that instructors can map uploaded materials directly to them..  This way, other instructors can search on a particular objective to find appropriate materials, so storing the entire file would not work.

Possibly the unicode types might work.  But how do I create a 'sigma' character, for instance and send it along with, let's say, an update to a particular math objective...

The application is an asp.net 2.0 app.

Maybe this is not possible.

Thanks
0
 
QlemoC++ DeveloperCommented:
This select does give you several ways to retrieve those chars. To find out Unicode number of chars, you can use the charmap.exe.

select  N'', nchar(0x2211), nchar(8721), nchar(unicode(N''))

Open in new window

0
 
vstackAuthor Commented:
I'll check this out.  Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now