• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • 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
 
PortletPaulfreelancerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

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