Collections:
String Type Conversion During Concatenation in SQL Server
What Happens When Unicode Strings Concatenate with Non-Unicode Strings in SQL Server Transact-SQL?
✍: FYIcenter.com
If a Unicode string NVARCHAR is concatenated with a non-Unicode string VARCHAR, SQL Server will implicitly convert the non-Unicode string to Unicode string for concatenation.
DECLARE @regcode VARCHAR(40); DECLARE @unicode NVARCHAR(40); SET @regcode = 'Some Unicode characters: ' SET @unicode = NCHAR(9733)+NCHAR(9734)+NCHAR(9792) +NCHAR(9794); SELECT @regcode + @unicode; SELECT DATALENGTH(@regcode); SELECT DATALENGTH(@unicode); SELECT DATALENGTH(@regcode + @unicode); Some Unicode characters: ???? 25 8 58
Note that the non-Unicode string @regcode has been converted to a Unicode string. The number of bytes of @regcode changed from 25 to 50. With 8 bytes from @unicode, the number of bytes of the concatenated string becomes 58.
⇒ Converting Unicode Strings to Non-Unicode Strings in SQL Server
⇐ Concatenating Two Character Strings in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-11, 1541🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...