Editor on SQL Server problem when data posted by Japanese

Editor on SQL Server problem when data posted by Japanese

szxszx Posts: 11Questions: 4Answers: 0
edited October 2017 in Free community support

I tried Basic Initialisasion on my local machine using Editor .NET package.
I used 'SQL Server Express' as database, and my language is Japanese.

My problem is that I can create new record but I cannot edit record correctly.
For example, after I created 'ใƒ†ใ‚นใƒˆ' record, it was converted to 'テスト' when I edit.

Anyone can help me?

  • OS: Windows10 Pro
  • Framework: .NET Framework 4.5
  • Database: SQL Server Express 12.0.2269

Replies

  • allanallan Posts: 61,439Questions: 1Answers: 10,053 Site admin

    That's odd. Are you able to have a look at what is stored in the database itself please? Is it the HTML encoded entities, or the original characters?

    Thanks,
    Allan

  • szxszx Posts: 11Questions: 4Answers: 0

    Thank you, Allan.
    The HTML encoded data was stored in database. Not the original characters.
    I've checked by SQL Server Management Studio.

    Thanks,
    Saito

  • allanallan Posts: 61,439Questions: 1Answers: 10,053 Site admin

    Thanks for checking that. My guess is that the Microsoft AntiXSS library which Editor uses is encoding the characters to their HTML entities.

    Could you try adding .Xss( false ) to your fields - e.g.:

    new Field( 'myFieldName' )
      .Xss( false )
    

    Thanks,
    Allan

  • szxszx Posts: 11Questions: 4Answers: 0

    Thank you very much, Allan.
    Completely fixed.

This discussion has been closed.