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

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

How to store this kind of questions in the database that involves mathematical questions.
The questions contains symbols.
FM-quiz-1.doc
0
searchsanjaysharma
Asked:
searchsanjaysharma
1 Solution
 
rpkhareCommented:
I think for special characters, NVARCHAR datatype is the right choice. It accepts Unicode characters.
0
 
chaauCommented:
I think the answers for question 20 can only be stored as images. In this case, the right data type is varbinary
0
 
PortletPaulCommented:
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
 
searchsanjaysharmaAuthor Commented:
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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