Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 collate

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2005-09-09 : 10:33:45
I have read about collation in table fields but still do not understand it.
It seems that it is to do with handling of the data in different languages...? and sorting...
I know that the tables created in Germany have the collate of German and other have latin...
What are all these please?
Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-09 : 10:39:49
collation are there so that sql server can properly wotk with different language specific characters.
for example:
in latin the list is sorted like this:
Osterich abc
Österich abc
Osterich bce
Österich bce

and in german it's like this:
Osterich abc
Osterich bce
Österich abc
Österich bce

what else don't you understand?

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -