Multilingual Editor for Web and Windows

Hi,

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
LVL 36
Loganathan NatarajanLAMP DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SStoryCommented:
I would compare the webpage from access to the what is returned from SQL Server to see if they match.

Is there a line about <meta charset="ISO-8859-1">  for UTF-8? Or do you not store an entire webpage, but only HTML that would be in the body?  It just sounds like a bad character set, maybe, or missing font.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Loganathan NatarajanLAMP DeveloperAuthor Commented:
Better let me check access & sql server data.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.