Converting Your Text from Latin to Cyrillic

In this blog you will learn how to create a function that will convert your text from Latin to Cyrillic in SQL Server.

Create a function that converts characters from Latin to Cyrillic in SQL Server

Imagine you have text which is written in Latin characters but you need them to be in Cyrillic characters. What will you do? Are you going to write that again from the beginning with Cyrillic characters? Of course not. Why lose all that precious time by typing again?

In this article I am going to show you how to create a scalar function that will convert your Latin characters into Cyrillic characters (Unicode). In this example I will convert from Latin to Cyrillic characters. You can use this function inside of your application as well if your application uses Microsoft SQL Server.

The process of creating the function that converts characters from Latin to Cyrillic is the following,

First of all we need two variables where we are going to store all characters for both Latin and Cyrillic. There will be some other variables as well for character, position and so on. After that we are going to create a WHILE loop and check every character and convert that character to Cyrillic.

You will have a better understanding once you take a look at the code snippet below,

CREATE FUNCTION [dbo].[to_cyrillic] (@src varchar(4000))
RETURNS nvarchar(4000) AS
BEGIN
DECLARE @latin nvarchar(100)
DECLARE @cyrillic nvarchar(100)
DECLARE @i int
DECLARE @character nvarchar(1)
DECLARE @position int
DECLARE @dest nvarchar(1000)

SET @src = UPPER(@src);
SET @latin = 'abvgd|e`zyijklqmnwoprst}ufhc~x{ABVGD\E@ZYIJKLQMNWOPRST]UFHC^X[';
SET @cyrillic =
-- All Cyrillic characters are shown as "???" (C-sharpcorner is not showing Cyrillic characters)
SET @dest = '';
SET @i = 1;

WHILE (@i <= LEN(@src))
BEGIN
SET @character = SUBSTRING(@src, @i, 1)
SET @position = CHARINDEX(@character, @latin)
IF (@position = 0) SET @dest = @dest + @character ELSE
BEGIN
IF ((ASCII(@character) < 96) AND (@position<32))
SET @dest = @dest + SUBSTRING(@cyrillic, @position+31, 1)
ELSE SET @dest = @dest + SUBSTRING(@cyrillic, @position, 1)
END
SET @i = @i + 1
END
RETURN @dest
END

Using the function above

To use the function you just need to use it in your SELECT statement. For example I am going to convert my name from Latin to Cyrillic characters.

select [dbo].[to_cyrillic]('BARLET') AS [Cyrillic characters]

When I run the query above I see that my name ‘BARLET’ is converted to ‘??????’. You can see the result in the picture below.