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, 7187🔥, 1💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...