Post reply

collation issue

  • April 30, 2008 at 2:57 am

    #206821

    i have two server

    server a - colaltion - SQL_LAtin1_general_cp1_cI_as

    d/b - collation - SQL_LAtin1_general_cp1_cI_as

    table a

    copied the d/b from server a to server b with

    server b - collation - SQL_Latin1_General_CP850_CI_AS

    d/b collation - SQL_LAtin1_general_cp1_cI_as

    table a -

    both tha table have same collation

    even the column has same colaltion

    i.e username

    [username] [nvarchar] (50) COLLATE Arabic_CI_AS NULL

    now when i query the table a on server b.... user name looks like junk data . i knwo this issue is due to colaltion cna anybody tell em how to solve this problem.

  • April 30, 2008 at 4:40 am

    #808912

    and also this problem arise when we are transferrign data from as400 system to sql server. so anything needs to be chnaged at the package level. there soes nt seem to be a issue with sql server having different collation. any guess as to what can the problem be?

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

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