May 7, 2009 at 6:19 am
Database Server has collation 'SQL_Latin1_General_CP1_CI_AS'
but one table has one column with collation 'Latin1_General_BIN'.
Before convert collation for this column,I want to export this table to my local database so,that any problem persist i can restore it.
I have export the table but collation is not same as 'Latin1_General_BIN' but it shows
'SQL_Latin1_General_CP1_CI_AS' which one is my local PC's collation.
Can I get any halp about
1. export table with column collation remains 'Latin1_General_BIN' OR
2. do not export the table i can change collation type vice versa without any affect to data.
May 7, 2009 at 10:32 am
Are you using the Import/Export Wizard to transfer from one db to another?
If so, the answer is to go to Edit Mappings... then Edit SQL... and change the create table statement, adding COLLATE LATIN1_GENERAL_BIN to the relevant column, or precreate the table in your environment before running the wizard with the correct collation.
May 7, 2009 at 11:53 pm
Ok. Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply