Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4738👍, 0💬
Popular Posts:
Should synchronization primitives be used on overrided bean methods? No. The EJB specification speci...
What is normalization? What are different types of normalization? It is set of rules that have been ...
How To Define a Sub Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A...
How To Use Subqueries with the IN Operator? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqu...
What will be printed as the result of the operation below: main() { int x=10, y=15; x = x++; y = ++y...