Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Best way to store special characters in mssql

Posted on 2010-01-07
Medium Priority
Last Modified: 2013-12-24
I am building a scientific manuscript application that would allow authors to input their manuscript information online which would be stored into a microsoft SQL 2005 database.  The data they input, title, authors, and manuscript information would then be used to display on the clients website via HTML as well as generating PDF's on the fly.
My issues are the following:  

1. What is the best way to have the client input this data (with the main issue being the special foreign characters, scientific formulas etc)?  Should I provide them with HTML text editor type boxes and just store this type of data as html?
2.  I have thousands of existing PDF documents that I need to input into a database that are in this format.  What would be the best suggestion for extracting this data to keep it in the same format.
I've attached a graphic sample of what one input would look like with the characters.  
Question by:polobruce
1 Comment
LVL 43

Accepted Solution

pcelba earned 2000 total points
ID: 26208614
HTML is just one option. You can store these data in many more formats like RTF or even MS Word DOC format which could contain structural formulas... All these formats must be handled at client side in appropriate form controls. OLE controls for all above formats are available. Above is valid for PDF, as well, but PDF is suitable just for archiving or reporting purposes because a possibility to update PDFs is restricted.

RTF control should be sufficient to create above document format.

The best data type for large binary contents at SQL Server is varbinary(max). It can keep binary documents of almost unlimited size. The way how to store and retrieve these files from SQL Server depends on client platform used.

You should also think about MS Sharepoint services to handle such large amount of your data. It was designed for this purpose.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This article focuses on how to remove password security from multiple PDF files by Adobe Acrobat program. Sometimes it is essential to access the stored data items and to print, edit as well as copy content from Portable Document Format files in abs…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this second video of the Xpdf series, we discuss and demonstrate the PDFimages utility, which, in a single command, is able to extract all the images from a PDF file and save each one in a separate image file (PBM, PPM, or JPG). Download and inst…
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

581 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