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 =
![]()
-
- 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
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]
![]()