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 String Functions Supported by SQL Server 2005 in SQL Server
⇐ String Type Conversion During Concatenation in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-07, 3867🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...