Best way to store special characters in mssql

Posted on 2010-01-07
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 41

    Accepted Solution

    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

    Network it in WD Red

    There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

    Join & Write a Comment

    Suggested Solutions

    *Adobe Acrobat 9 was used for this article. Particular steps may vary depending on software versions. 1. Create a framework of your form in Word, leaving space where you’d ultimately like the Adobe fields to appear.  (Note: I use the blank lines …
    Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
    In this first video of the three-part Xpdf series, we introduce and describe Xpdf, a library containing nine command line utilities that perform various functions on PDF files. We show where the library is located and how to download it, discuss its…
    In this video, we show how to perform Bates Numbering/Stamping of PDF documents using Power PDF Advanced, the newest product from the Document Imaging division of Nuance Communications. There are two editions of Power PDF — Standard and Advanced. Th…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now