changing the code page


  • 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

    Wednesday, September 25, 2013 11:58 AM

All replies