BCP parameter for Unicode files

• cutespn

  SSCommitted

  Points: 1669

  More actions

  March 22, 2004 at 8:31 am

  #86303

  Hi,

  Can any one suggest the bcp parameter for importing file , which is in unicode format, delimeted by tabs. i tried -w, -N all in vain 🙁

   

  TIA,

  sudheer

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 22, 2004 at 8:04 pm

  #499933

  Those are the options, what was your entire string and what message did you get? Also what server version are you using?

• cutespn

  SSCommitted

  Points: 1669

  More actions

  March 22, 2004 at 10:14 pm

  #499940

  HI,

  i m using sql server 2000 .

  Error message is

  SQLState = 22005, NativeError = 0

  Error = [Microsoft][ODBC SQL Server Driver]Invalid

  character value for cast spec

  ification

  and string i used for bcp is

  bcp <DBname>..<tablename> in

  D:\a.dat -S<servername> -T -m0 -w

   

  TIA,

  sudheer

   

   

   

  
  
  
  
  
  

  Regards,
  Sudheer