How can i use ö ü ä with MySql and .net

teledialog-edv

Hi,

i'm using DataTables-Editor-Server for .net 4.7 and a mysql database (Encoding utf8) and not able to store ä ü ö correctly in the database.
If i try to delete a row i get an System.Web.HttpRequestValidationException

colin

Hi @teledialog-edv ,

There's a few threads on this forum that you can try first that may help, such as this and this. If no joy, let us know, and we can dig deeper,

Cheers,

Colin

teledialog-edv

Database Collation (mysql 5.5)

data stored in database

data shown on website

after trying to delete

Hi colin,

thank you for your answer. I know those threads and read a lot of them before i was starting a discussion.
I'm not using php. I'm using the DataTables-Editor-Server.dll for .Net

Best Regards,
Willi

allan

Try adding .Xss(false) to your Field instances. I believe the encoding is coming from Microsoft's XSS library.

Allan

teledialog-edv

Hi allan,

thank's a lot. That solved my problem!

Best Regards,
willi