Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How do we define collation sequence for database and tables
How do we define collation sequence for database and tables?
✍: Guest
You can create a database with language specific collation sequence. For instance in the
below create statement tblCustomer is created by Latin language collation sequence.
Create database tblCustomer collate Latin1_General_BIN
You can also create tables with particular collation sequence. Below is the create table
syntax for the same.
Create table tblCustomer ( [CustomerCode] char(10) COLLATE Albanian_CI_AI_KS_WS NULL, [EntryDate] [char] (8) COLLATE Korean_Wansung_Unicode_CS_AS_KS NOT NULL , [CustAbbrev] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL )
2007-11-02, 4886👍, 0💬
Popular Posts:
How To Delete a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privilege...
What Is the Difference between Formal Parameters and Actual Parameters? - Oracle DBA FAQ - Creating ...
What is the significance of Finalize method in .NET? .NET Garbage collector does almost all clean up...
How do we configure “WebGarden”? “Web garden” can be configured by using process model settings in...
How To Assign Query Results to Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL...