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.
| Author |
Topic |
|
emundorf
Starting Member
15 Posts |
 Posted - 2007-04-10 : 08:29:18
|
| I have developed a tool to allow project developers to easily re-create the entire schema for our base product. The current issue involves setting the correct collation for the customers' region. Our brother company in Germany uses the same db creation tool and scripts, and we here in the US also have customers in South America. My ultimate question is "what subset of collation names would be necessary to provide the project developer?" I could query the database to get all the collation names, but I think it was around 1000 names. Can I query to get a smaller subset of the most relevant collation names?Ed |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-10 : 08:32:22
|
| "most relevant" is subjective term. You will have to define what collations you want and list them.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
emundorf
Starting Member
15 Posts |
Posted - 2007-04-10 : 08:45:49
|
| When I say most relevant, maybe for now it's just German, English and Spanish (South America). The trouble is that it's hard to find a definitive list of collation names for each. Can you tell me which collation names match up? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-10 : 08:51:28
|
| [code]select * from ::fn_helpcollations() where name like '%GERMAn%' or name like '%SQL_Latin1%' or name like '%Spanish%'[/code]You will have to decide based on description which one are suitable for you.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
English and German Collations