This is the definition of collate on books online. When I was helping my colleagues solve a database problem today, I encountered the cannot resolve collation conflict for equal to operation,Update sec_usrdata
Set userid = new_id
From sec_usrdata,
1.sp_helpsort SELECT serverproperty (' collation ')See your sorting rules.But you should have something to do with the character set.2. Change Server Collation Changing the default collation of an instance of SQL Server 2005 can be complex,
SQL Server collation is not usually used a lot, perhaps many beginners are still relatively unfamiliar, but there
An error should be often encountered: SQL Server database, in the cross-Library multiple table connection query, if two data
The
In SQL Server, the character type primarily refers to single-byte characters (Char,varchar) and Unicode characters (Nchar,nvarchar). The sort and comparison of character types is determined by collation. For single-byte characters, collation
The concept of character set is clear to everyone. Many people do not understand the proofreading rules. This concept is not used in general database development. mysql seems very advanced in convenience.
The concept of character set is clear to
In SQL Server, Collation determines the byte representation and code Page of a varchar or char field. In a memory-optimized table, the column of the character type (Varchar,char,nvarchar,nchar) must use the collation of code page=1252, if
Brief Description
Character Set and verification rulesCharacter Set is a set of symbols and encoding. A collation is a set of rules used to compare characters in a character set.MySql provides strong support in collation, and mongoel does not find
First, sorting rulesSometimes when we insert text into the database, there is a garbled "?", it is possible that we created the database is not set up collationTaking Chinese_prc_ci_as as an exampleThe first half of CHINESE_PRC refers to the
stored procedure authoring experience and optimization measures One, suitable for the reader object: Database development programmer, database of a lot of data, involving the SP (stored procedure) optimization of project developers, the database has
Sometimes when querying the database will be found (such as when the name of the duplicate check): The database query is not sensitive to case, that is, a and a are the same. That is to say select * from tabletest where name = ' A ' and select *
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.