MS SQL Turkish Character Problem

Unicode Character

If you are experiencing the problem of Turkish characters appearing as meaningless characters when sending data from the form to MS Sql with C#, or the letters “sgi” in Turkish are recorded in the database as “sgi” respectively, the solution is very simple. You sent the letter Ş from the form, but when you edit the records in the database, you saw that the letter you sent was the letter s. The only thing you need to do is to change the Collation setting of the relevant db from the Sql manager interface.

Connect to your SQL server with Microsoft SQL Server Management Studio and find the database you are working with, right click on it and go to Properties. In the section that says Select a page, click on the Options link. A page similar to this will open;

In this window, click on the first row where it says SQL_Latin 1_General and change this setting to Turkish_CI_AS. Then try submitting your distressed characters from the form and saving them to the database again. You will see that your Turkish characters are saved to the database without any problems.

Important reminder:

While making this setting, no client should be connected to the database and if it is open in Visual Studio program, you should close it. Also, if any table of the database is open in MS SQL Manager, you may get an error message as a result of the operation. For this reason, try the method by closing all tables. Otherwise, it will give an error when you perform this operation.