Fixing Turkish Characters in a Text in SQL Server

Hello everyone,

In this article, I will try to give information about correcting Turkish characters in a text in SQL Server.

In SQL Server, in some cases, you may want to correct Turkish characters in a text.

You can easily do this using the code below.

DECLARE @Yazi VARCHAR(MAX) = 'kaldırım taşları';
SELECT
	REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@Yazi, 'ğ', 'g'), 'ü', 'u'), 'ı', 'i'), 'ş', 's'), 'ö', 'o'), 'ç', 'c');

When you run the above code, you will see a result like the one below.

Fixing Turkish Characters in a Text in SQL Server

As you can see, we have corrected the Turkish characters in a text.

Good luck to everyone in business and life.

43 Views

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!