Ask - how to insert and retrive chemical formula in sql databse

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

how to insert and retrive chemical formula in sql databse

Apr 10 2012 12:00AM by pankajkiit06

I am designing a project for online test series for all subject like mathematics, physics, chemistry, . I have a problem in storing mathematical equation which includes special symbols an in organic chemistry structural formulas etc.How can we store it in sql server 2005 database .i tryed by importing the mathematical and chemical formula in SQL server database using.XLS file but in place of chemical formula and mathematical equation its showing null or different character.in database. after storing it i want to retrive it on asp.net web page. Your's sincerely PANKAJ

Submitted under: Microsoft SQL Server · String Operations · DBA · TSQL · DATABASE DESIGN

pankajkiit06

558 · 0% · 65

3 Replies

Can you please tell me what is the datatype you have for the column you are storing formula in?

commented on Apr 11 2012 12:08AM

Ritesh Shah

75 · 2% · 747

i have tryed with nvarchar(max) and with image data type but iam unable to retrive it on asp.net page because if iam storing the symbols in form of image in database its storing it as binaryvalue and iam not able to get the same value which i have stored it in the form of image:(

commented on Apr 11 2012 9:58PM

pankajkiit06

558 · 0% · 65

Can you please give me the same formula to check from my end?

commented on Apr 11 2012 10:06PM

Ritesh Shah

75 · 2% · 747

Your Reply

Sign Up or Login to post a comment.