February 3, 2011 at 1:26 pm
Hi all-
I was hoping that someone could help me answer this question. I've tried researching it for a while...
I have a database installed on the Spanish Version of SQL Server; the collation is set to default (which one of the Spanish collations). We take a backup of that database and put it on English Version of SQL Server, where the default collation is SQL_Latin1_General_CP1_CI_AS. After the restore, the properties say that the collation is SQL_Latin1_General_CP1_CI_AS. If I change it to Modern_Spanish_100_CI_AS, will the data in the restored database still be "Spanish," since it originated on a Spanish SQL Server or will it be "English," since it was restored on a English Version. I know that by changing the collation of the restored database it only affects the data inserted going forth, not the data that is already in the database.
I hope my question makes sense. Please let me know if it doesn't.
Thanks in advance!
February 3, 2011 at 9:17 pm
The bigger question (that will have more of an impact on you I suspect) is what is the collation on the fields, they should still be what the database was created in (so the Spanish collation) if so then your data should be fine.
February 4, 2011 at 6:56 am
I am told the original database and tables have the Spanish collation, I don't have access to the original database to verify.
I guess I wasn't sure if the restore process affected the original collation or not. If not, I should be good-to-go.
I've been restoring the database and importing the data into a separate Spanish collation database just to make sure that all the data was in Spanish. But, this process is long....
Thanks for your input!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply