MS SQL Turkish-Unicode Character Problem

When you make a record on an MS SQL-defined database through your project, if you have a character problem, that is, characters such as“SsCcIiUuGgOo” that you write in the project are a common problem that is seen as“SsCcIiUuGgOo” in the database. The solution is very simple. When designing the database using MS SQL data types, you define the field in char, varchar, text type for string data. When defined in this way, it is inevitable that you will encounter the above problem.

For this reason, when defining a string field, it is designed as nchar, nvarchar, ntext so that Turkish character sets and other non-Latin characters can be entered. Thus, the inside of the field in question will be Uniq. So you will have solved this problem.

You may be blocked by MS SQL while doing this. You can prevent this error by unchecking Prevent saving changes that require table re-creation in the Designers tab in the Options section of the SQL Manager Program.