This question has already been answered:

When editing the database through Sql Managment Studio, umlauts are inserted without problems. But it is worth editing as a request UPDATE docsTbl SET prim='ş' then the letter s is placed in the base. What to do, please tell me !!!

Reported as a duplicate by PashaPash member ♦ Jul 21 '16 at 5:09 .

A similar question was asked earlier and an answer has already been received. If the answers provided are not exhaustive, please ask a new question .

  • "But it is worth editing as a request" - and what are you editing and executing the request, not in the studio? - Kromster
  • request also asked in the studio - zodiac

1 answer 1

Found the answer: UPDATE docsTbl SET prim=N'ş' - the letter N must be set everywhere.

The certificate says that the prefix N will write the text in Unicode, and without it - in the default code page of the database:

Prefix Unicode Character String Constants with the letter N. Do not recognize certain characters.

  • Added a link to help. Do you have MS SQL? - Kromster