SQL Server Performance

Converting nvarchar to varchar or vice versa

Discussion in 'SQL Server 2008 General Developer Questions' started by mikejywood, Apr 13, 2010.

  1. mikejywood New Member

    I have a SQL 2008 DB with unicode data stored as nvarchar. I recently been given some data stored as varchar that includes data from Japan, China, etc. I need to compare both of these datasets, joining the nvarchars to the varchars.
    I know that I can implicetly compare varchar to nvarchar but in this case the Japanese data stored as an nvarchar (and properly displaying in management studio) can not match to the data stored as a varchar.
    Assuming I know the code page how can I cast, convert, collate, or whatknot so I can compare the nvarchar data and the varchar data. Is there a way to make the varchars look like the nvarchars or the nvarchars look like the varchars so I can join the data together?
    Thanks for the help,
  2. satya Moderator

  3. paresh_sqldba New Member

    You need to translate varchar data in to another language by google translator then compare it with nvarchar data.

Share This Page