| Computers Forum Index » Computer - Databases - MS SQL Server » I'm a New bie to SQL SERVER 2005... |
|
Page 1 of 1 |
|
| Author |
Message |
| althafexcel at (no spam) gmail.com... |
 Posted: Tue Sep 29, 2009 4:47 pm |
|
|
|
Guest
|
Hi
I'm using SQL Server 2005 on a .NET project that deals with multiple
languages, During installation i made the SQL collation to default.
But as of now i will be using English & Arabic languages in my
project, how do i set the collation now.
Should i have to change the COLLATION for the whole SQL SERVER 2005 or
for the new database that i will be creating for my project. Please
advice me the steps on how to set the collation.
What about if i include the FRENCH & SPANISH language too in the same
project. I'm very confused, plz. help me out guys... |
|
|
| Back to top |
|
|
|
| David Portas... |
| Posted: Tue Sep 29, 2009 9:57 pm |
|
|
|
Guest
|
<althafexcel at (no spam) gmail.com> wrote in message
news:32a8af17-5c8a-49ea-9380-4cc7b212e548 at (no spam) h13g2000yqk.googlegroups.com...
Quote: Hi
I'm using SQL Server 2005 on a .NET project that deals with multiple
languages, During installation i made the SQL collation to default.
But as of now i will be using English & Arabic languages in my
project, how do i set the collation now.
Should i have to change the COLLATION for the whole SQL SERVER 2005 or
for the new database that i will be creating for my project. Please
advice me the steps on how to set the collation.
What about if i include the FRENCH & SPANISH language too in the same
project. I'm very confused, plz. help me out guys...
It is the *column* collation rather than the server or database collation
that determines the way data is sorted and compared. Since you are using
multiple languages you will perhaps want to control sorting and comparison
at runtime rather than design time. Use the COLLATE clause in a query for
that. None of the collation settings affects the way data is stored. They
only determine how it is compared and sorted.
--
David Portas |
|
|
| Back to top |
|
|
|
|
