Function to Fix Turkish Character Problem in SQL Server

Hello to everyone,

In this article, I will give information about the function that fixes the Turkish character problem in SQL Server.

First of all, there are other solutions to this process. Please also research these methods before using functions.

You may experience Turkish character problems in SQL Server in some cases.

You can easily solve this problem by using the function below.

--Creating the function

CREATE FUNCTION fn_FixTurkishCharacterIssue
(
    @Writing NVARCHAR(MAX)
)
RETURNS NVARCHAR(MAX)
AS
BEGIN

    DECLARE @Result NVARCHAR(MAX);
    SET @Result = @Writing;
    SET @Result = REPLACE(@Result COLLATE Latin1_General_BIN, N'ð', N'ğ');
    SET @Result = REPLACE(@Result COLLATE Latin1_General_BIN, N'ð', N'Ğ');
    SET @Result = REPLACE(@Result COLLATE Latin1_General_BIN, N'Ð', N'Ğ');
    SET @Result = REPLACE(@Result COLLATE Latin1_General_BIN, N'ý', N'ı');
    SET @Result = REPLACE(@Result COLLATE Latin1_General_BIN, N'Ý', N'İ');
    SET @Result = REPLACE(@Result COLLATE Latin1_General_BIN, N'þ', N'ş');
    SET @Result = REPLACE(@Result COLLATE Latin1_General_BIN, N'Þ', N'Ş');
    RETURN @Result COLLATE Turkish_CI_AS;

END;


--Using the function


SELECT dbo.fn_FixTurkishCharacterIssue(N'þýrýnga');

When you create the function and run the code, you will see a result similar to the one below.

Function to Fix Turkish Character Problem in SQL Server

As you can see, the Turkish character problem has been fixed.

Good luck to everyone in business and life.

136 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!