?
Solved

How to store questions in a table that contains mathematical symbols.

Posted on 2013-06-10
4
Medium Priority
?
208 Views
Last Modified: 2013-06-12
How to store this kind of questions in the database that involves mathematical questions.
The questions contains symbols.
FM-quiz-1.doc
0
Comment
Question by:searchsanjaysharma
[X]
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
4 Comments
 
LVL 8

Expert Comment

by:rpkhare
ID: 39235534
I think for special characters, NVARCHAR datatype is the right choice. It accepts Unicode characters.
0
 
LVL 25

Expert Comment

by:chaau
ID: 39236271
I think the answers for question 20 can only be stored as images. In this case, the right data type is varbinary
0
 
LVL 49

Accepted Solution

by:
PortletPaul earned 1000 total points
ID: 39236492
I guess the first point is there are questions, and there are options (for each question) and the questions appear to be purely varchar or nvarchar (I'd go with nvarchar)

It would seem a pity to have to use images for all options as so many are text, however these indicate "issues":
Q6 Options:
(a) M–1L3       (b) ML–3       (c) MLT–1       (d) M–1L–1T.

q12 Options
(a) dp = –¿dz             (b) dp = –¿dz             (c) d¿¿= –¿dz             (d) dp = –zd¿

q20 Options
(even in Word 3 of 4 are images)
The reason for pasting in those options is to highlight the possibility that different methods of rendering may present some challenges.

e.g.
http://en.wikipedia.org/wiki/Help:Displaying_a_formula
http://en.wikipedia.org/wiki/Help:Displaying_a_formula#Pros_of_HTML

http://www.univie.ac.at/moe/formeln.html

How do you intend to deliver this test? Through a web browser?
MAYBE, the formulae could be represented in html? (in which case nvarchar could be used.)
0
 

Author Comment

by:searchsanjaysharma
ID: 39236970
The test would be on Windows based application in Vb.Net.

I was thinking to fethc the questions dynamically based on the difficulty level.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

752 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