Discover how to use collate in sql, include the articles, news, trends, analysis and practical advice about how to use collate in sql on alibabacloud.com
When creating table, we often encounter such a statement, for example, password nvarchar (10) Collate chinese_prc_ci_as null. What does it mean? Take a look at the following:
First, collate is a clause that can be applied to database definitions
When creating table, we often encounter such a statement, for example, password nvarchar (10) Collate chinese_prc_ci_as null. What does it mean? Take a look at the following:
First, collate is a clause that can be applied to database definitions or
From: http://www.cnblogs.com/peipei2009/archive/2009/05/08/1452516.html
When creating table, we often encounter such a statement, for example, password nvarchar (10) Collate chinese_prc_ci_as null. What does it mean? Take a look at the
When creating table, we often encounter such a statement, for example, password nvarchar (10) Collate chinese_prc_ci_as null. What does it mean? Take a look at the following:
First, collate is a clause that can be applied to database definitions or
Khan, today by the SQL Server COLLATE clause big play a, watch online help not careful! Let yourself around a large circle, later look at Ms Help to be careful, the thing is this:
Afternoon, the eldest brother sent us a section of SQL Script, we
Collate is a clause that can be applied to database or column definitions to define sorting rules, or to string expressions to apply sorting rule conversion.
Syntax
Collate { | database_default}
::=
{Windows_collation_name} | {SQL
When creating table, we often encounter such a statement, for example, corpname nvarchar (10) Collate chinese_prc_ci_as null. What does it mean?
Take a look at the following:
Syntax
Collate
::={Windows_collation_name} | {SQL
1. make sure that no other person is connected to the current database. you can use sp_who to view the connection, and then use kill @ spid to forcibly close the connection. 2. run the SQL statement to modify the Collate attribute of the database,
1. To determine that no one else is connected to the current database. You can view it with sp_who, and then use the kill @spid force it to close its connection.
2. Execute SQL, modify DB's Collate property
Use [master]
Go
ALTER DATABASE [my_db]
You encounter collate conflicts when using SQL to query a table, such as:Select from [dbo]. VmimageunionSelect from [dbo]. [Dicvmimage]Get the error:468 - 9 1 "chinese_prc_ci_as" "sql_latin1_general_cp1_ci_as" in the UNION operation.The initial
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.