Collections:
Converting Unicode Strings to Non-Unicode Strings in SQL Server
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL?
✍: FYIcenter.com
Since Unicode character set is different than code page based (non-Unicode) character set, converting Unicode strings to non-Unicode strings may result in wrong characters or missing characters. So you should avoid converting Unicode strings to non-Unicode strings.
If you really want to, there are 3 ways to convert a Unicode string to a non-Unicode string:
Some numeric data type conversion examples are provided in the tutorial exercise below:
-- Implicit conversion by an assignment operation DECLARE @regcode VARCHAR(40); SET @regcode = N'Some Unicode characters: ' + NCHAR(9733)+NCHAR(9734)+NCHAR(9792)+NCHAR(9794); SELECT @regcode; GO Some Unicode characters: ???? -- Explicit conversion by CAST() SELECT CAST(N'Some Unicode characters: ' + NCHAR(9733)+NCHAR(9734)+NCHAR(9792)+NCHAR(9794) AS VARCHAR(40)); GO Some Unicode characters: ???? -- Explicit conversion by CONVERT() SELECT CONVERT(VARCHAR(40), N'Some Unicode characters: ' + NCHAR(9733)+NCHAR(9734)+NCHAR(9792)+NCHAR(9794)); GO Some Unicode characters: ????
⇒Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-07, 819👍, 0💬
Popular Posts:
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...