Is there a way to change the code page in sql server.
tried using collation for different collation it gives the same code page .i need to convert from 1252 to 37
COLLATIONPROPERTY( collation_name , property )
select COLLATIONPROPERTY( 'SQL_EBCDIC037_CP1_CS_AS' , 'CodePage')
select COLLATIONPROPERTY( 'Latin1_General_CS_AS_KS_WS' , 'CodePage')
could you please help
we tried creating a databse with the collation
SQL_EBCDIC037_CP1_CS_AS but in ssis oledb task it shows an error unable to converrt 37 code page to 1256 code page
we are using Ebcdic file as source and SQL db with the collation applied.
- Merged by Mike YinMicrosoft contingent staff, Moderator Thursday, October 03, 2013 2:03 AM duplicate
I would recommend you re-install the instance and choose the desired COLLATION while installation is running up.
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence