I am developing a windows application which has an editor to save the text entered in any language. I need to save the text entered in MSACCESS. I have the datatype as Memo. It saves the entire text as html with font set such as "Bamini" or respective text's font as I type in editor.
Now I need to push all those ms access entries to SQL server and I have the datatype set as nvarchar. I am not able to see the html rendered as it is in the browser.
Example: I typed tamil text in windows app and it is saved in ms access with style added as font-family as bamini. I pushed the same entry to sqlserver. I need to fetch this record and show in website, while showing it shows as different characters instead of tamil text.
I hope I have explained my problem clearly. Please suggest a best way to solve this issue or am I making any mistake in saving the entries. I am using Devexpress rich text editor for windows application and ck editor for web application.
If I set the font as Bamini in editor and type the text from the keyboard it saves as english character, whereas It I copy paste tamil text or set tamil keyboard and Type I don't face any issue
Please help me on this