Solved

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

Posted on 2013-06-10
4
202 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
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 24

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 48

Accepted Solution

by:
PortletPaul earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 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