Unicode INSERT

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  January 15, 2003 at 4:48 am

  #80668

  Hey,

  We have to import some contacts into a database. As these contacts are Swiss, we have an issue with international charachters, so I need to use nvarchar to support this....This is a two step process.

  First process is to import from Excel into a import table. No problem here. I select from the import table and all of the international characters are correct.

  Second step is to move it to an upload table (to be uploaded to Siebel). So I run a simple INSERT statement, SELECTing data from the original import statement. All of the international characters are now lost and replaced by strange characters...

  I have checked the design of each table, and both have nvarchar data types on the correct fields (name, company, address, city etc).

  Am I missing something from my query?! Here is my INSERT statement..

  INSERT INTO SWISS (FST_NAME, LAST_NAME, SALUTATION, JOB_TITLE, NAME, MAIN_PH_NUM, MAIN_FAX_NUM, ADDR, CITY, ZIPCODE, COUNTRY,

  [ACCOUNT TYPE], DATASOURCE)

  SELECT [First Name], [Last Name], [Mr/Mrs], [Job Title], [Account], [Telefon], [Telefax],

  [Adress], [City], [Post Code], [Country], [Account Type], [Data Source]

  FROM Swiss_Import

  Thanks,

  Clive

  Clive Strong

  sqlsrvr_dba@hotmail.com

• January 20, 2003 at 8:00 am

  This was removed by the editor as SPAM