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, 4240👍, 1💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...