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); ----- ★☆♀♂
⇒ Exact Numeric Literals in SQL Server Transact-SQL
⇐ Unicode String Literals in SQL Server Transact-SQL
2019-12-05, 6341🔥, 1💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...