Unicode symbols revisited

[Fit2Page]

Hi,
I am trying to insert some "higher" Unicode symbols in DB.

For instance the omega symbol becomes "O" in DB record.
As other thread advise I did set my SQL Server columns to varchar, nvarchar, char but to no avail.
I see that the "Save to DB" demo on your site is working correctly with the Omega symbol.

What could be the problem you think?

Regards,
Marc

[Rumen]

Hi Marc,

Please, make sure that your globalization settings are set to UTF-8 as it is shown in this help article:
Appearance of odd characters after saving RadEditor's content in Database.

Greetings,
Rumen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Fit2Page]

Hi Rumen,

All these were already set. The problem was that in the query I had

...tekst = 'tekst'...

And that must be

...tekst = N'tekst'...

following the guide on http://support.microsoft.com/kb/239530

Maybe you should add this one on http://www.telerik.com/help/aspnet/editor/appearanceofoddcharactersaftersavingradeditorscontentindatabase.html

Thanks for your time

Marc

[Rumen]

Hi Marc,

Thank you for sharing the solution with our community.  I will definitely update the help article.

Your Telerik points were updated for sharing your solution with Telerik community.

Sincerely,
Rumen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.