Collections:
Unicode Character String Literals in SQL Server Transact-SQL
How To Enter Unicode Character String Literals in SQL Server Transact-SQL?
✍: FYIcenter.com
Unicode characters are multi-byte characters. They are very hard to be entered as string literals, because it requires:
But if you know the code value of a Unicode character, you can enter it with the help of the NCHAR(int) function. For example:
-- A Unicode string of some interesting characters PRINT NCHAR(9733)+NCHAR(9734)+NCHAR(9792)+NCHAR(9794); ----- ★☆♀♂
Â
2019-12-05, 5858👍, 1💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...