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, 6549🔥, 1💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...