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

Posted on 2008-10-19
Last Modified: 2012-05-05
I have an app that reads a text file containing course objectives and stores in SQL db.  When the 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?
Question by:vstack
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 37

Accepted Solution

momi_sabag earned 200 total points
ID: 22752355
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
LVL 69

Assisted Solution

Qlemo earned 300 total points
ID: 22752363
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).

Author Comment

ID: 22753002
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 2.0 app.

Maybe this is not possible.

LVL 69

Assisted Solution

Qlemo earned 300 total points
ID: 22768915
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


Author Comment

ID: 22769913
I'll check this out.  Thanks

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question