SQL Server in front plus n explanation

Source: Internet
Author: User

from: http://lzde360.blog.163.com/blog/static/6780720820111026112033917/

Plus N represents storage in Unicode format when stored in a database.  N ' string ' means string is a Unicode string    The format of a Unicode string is similar to a normal string, but preceded by an n identifier (n stands for the International language (national Language) in the SQL-92 standard). The N prefix must be uppercase. For example, ' Michél ' is a string constant and N ' Michél ' is a Unicode constant. Unicode constants are interpreted as Unicode data and are not evaluated using code pages. Unicode constants do have collations that are primarily used to control comparisons and case sensitivity. Assigns the default collation of the current database to a Unicode constant unless the collation is specified with the COLLATE clause. Each character in the Unicode data is stored using two bytes, and each character in the character data is stored with one byte. For more information, see Working with Unicode data.    Unicode string constants support enhanced collations.

----------------->>>

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.