Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

Using the import/export wizard I end up with an annoying problem:

Error 0xc02020f4: Data Flow Task 1: The column "pinNumber" cannot be processed because more than one code page (874 and 1252) are specified for it.

Looks like a different codepage (SQL_Latin1_General_CI_AS vs Latin1_General_CI_AS), so I changed those to match: Latin1_General_CI_AS for both.

However the wizard still throws an error and detects two codepages - I even checked the tables and both source and dest show the same Latin1_General_CI_AS collation.

share|improve this question
What database are you using? – Phil Aug 5 '12 at 2:16
Plus, why are you trying to steal "pinNumber" ? :) – Phil Aug 5 '12 at 2:17
Is this between two instances of SQL Server on different hosts, or between two instances of SQL Server on the same host, or two databases on the same instance? SQL Server sets the code page (based on the Windows code page) for an instance when you install it, and AFAIK that can't be changed. – Simon Righarts Aug 5 '12 at 10:37
one is MSSQL 2005 and other is 2008 instance installed on the same serverbox. Thing is i can import/export my other DB-s, only this one seems to have a problem. – Agony Aug 5 '12 at 12:22
1  
Columns have collations associated with them -- changing the collation at a higher-up level only sets the default for new objects, it doesn't change existing objects. I'm pretty sure the columns still have different collations, and that's the problem. – Jon Seigel Aug 5 '12 at 15:25
show 1 more comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.