transferring data between dbs with different collations

• AndyLoughman

  SSC-Addicted

  Points: 422

  More actions

  November 17, 2004 at 6:53 am

  #59731

  Hi,

  I need to tarnsfer data on an ongoing basis from database A to database B . Both databases have different collations. Is it possible to use DTS to do this ?  Am thinking i could use collate clause.

  Many thanks in advance

   

• NeilA-162437

  SSC Enthusiast

  Points: 188

  More actions

  November 18, 2004 at 2:34 am

  #530599

  You can 'translate' between collations on the fly if needed

  For example, on the pubs..employee table the pub_id column on my machine is defined as

   [pub_id] [char] (4) COLLATE Latin1_General_CI_AS NOT NULL ,

  However I can issue this query to return the data both ways (note the first way does not need the collate part as it is already in that format)

  select pub_id COLLATE Latin1_General_CI_AS as X,

  pub_id COLLATE SQL_Latin1_General_CP1_CI_AS as Y

  from employee

  hth

  Neil.