Post reply

Need Help to change Collation for a table.

  • July 25, 2012 at 4:39 am

    #278482

    Hi Friends,

    I imported a Table named 'A' from X database to Y database.

    the Collation for the Table A in X database is SQL_Latin1_General_CP1_CI_AS

    and i wanted to change the Collation for the table A in database Y as

    Latin1_General_CI_AS_KS_WS

    The table has near about 150 + columns , in those near about 70+ are varchar and nvarchar datatype.

    i changed the collation as follows.

    ALTER TABLE table-name

    ALTER COLUMN col1 varchar(10) COLLATE Latin1_General_CI_AS_KS_WS

    by using Cursor, i scrolled all the 70+ columns and changed the collation using the dynamic query.

    All i asking from you that,

    is there any system defined funcation available to change the collation of the table.

    Please do let me know in case of any addtional required.

    Thanks in advance.

    :-):-)

  • July 25, 2012 at 4:59 am

    #1517275

    Nope, there's no built in way to do it - pretty much forced to roll our own solutions, as you've done.

    The other way would be to create empty tables with the correct collation & copy the data in.

  • July 25, 2012 at 8:40 am

    #1517397

    Thanks , seems to be there is no predifined system procedure for this.

    Thank you very much.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply