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 |
|
RIKIL
Starting Member
20 Posts |
 Posted - 2007-06-20 : 13:52:25
|
| I have a tricky situation here that I can't seem to get around.My SQL server had the wrong collation so I need to chage it. I am trying to install SQL to use a certain collation (SQL_Latin1_General_CP1_CI_AS). For some reason when I install SQL server the Code Page is getting set to 437 which is MS DOS U.S. English instead of 1 which is Latin1 (ANSI). Uninstalling and reinstalling SQL and choosing Latin1 results in the same collation. How can we install SQL and force the correct collation and Code Page?Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 14:04:53
|
| SQL_Latin1_General_CP1_CI_AS is default collation, sql will use it if you didn't make any change during installation. |
 |
|
|
RIKIL
Starting Member
20 Posts |
Posted - 2007-06-20 : 14:46:23
|
quote:
Originally posted by rmiao
SQL_Latin1_General_CP1_CI_AS is default collation, sql will use it if you didn't make any change during installation.
Yes, I completely understand this. I am leaving it default during install, which should install using Latin1. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 16:35:58
|
| Can't tell why didn't work for you. |
|
|
|
|
|
|
Collation trouble