Collations
-
Hi All,
I am looking for real good information on collations which includes charactrer-sets, binary sort order etc.
Can we restore a database of Server A of Ploish collation to Server B of Turkish collation ? This is just a example. But in real-time, it may be any kind of database that we would have any types of collation on a Server which may need to be restored on a different Server which has a different collation set ?
Please throw more light on this topic.
Any help is greatly appreciated.
--Kishore
-
To answer your specific question, yes, you can restore a database of whatever collation to a server with whatever default collation. With SQL 2000 collation is actaully controlled down to the column level. The server's default collation is merely the collatation that will be used for the system databases, new user databases will inherit their collation from model unless a different collation is specified on creation. Further the database's default collation merely indicates the collation that any new columns will inherit unless otherwise specified on creation.
HTH
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
You can but watch out for the temp tables "gotcha"
if you procedures create temp tables those are going to be created using tempdb collation !!! If those procedures do not account for that you will have to either chang the procedures code or modify the Model
Cheers!
* Noel -
Thanks for the information.
From what I understand now is that I can restore a database on one server of one collation to another server of different collation. Here the restored database will retain the collation of original database. So does SQL Server handles this automatically.
Second, we use Unicode for multi-language support.
When we say "I have a database of Binary sort order" ... what do we actually mean by that ? Can we restore database of binary sort order Server to another server of different sort order. ?
Please provide with the following information.
--Kishore.
-
First off you need to realize that the collation affects only non-unicode character columns with the exception of sort order. The sort order specified in your collation applies to both unicode and non-unicode data.
Binary order is one of two options generally available for any code page, the other is Dictionary sort order. (there are others but these are the primary ones) Dictionary order collations will evaluate expressions according to the data representation dictionary rules (a before b for latin etc...) This is how most of us are used to seeing data presented and compared. To understand Binary sort order, you have to keep in mind that the data is actually stored in 1's and 0's. So Binary sort order tells SQL to perform comparrision and sort operations according to the actual binary values rather than by the data representation. It is the code page that dictates which characters those 1's and 0's are actually translated into and presented as.
HTH
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
Oh yeah, just to directly answer your question... Since sort order is part of the collation, everything I and noeld said about collations is true about sort order.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply