OPENROWSET METHOD For unicode Charchters

• sdhere-901168

  SSC Journeyman

  Points: 81

  More actions

  October 6, 2008 at 3:23 am

  #382944

  SELECT *

  FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Text;Database=C:\TEST\;HDR=NO',

  'SELECT * FROM test1.csv')

  my test.csv contains unicode charchters like Japan,Mori Ogai,日本,森鷗外 Japan,Tex Texin,日本,テクス テクサン

  When we import this data in to table it reurns null row .

  Please help me for this.

• J-F Bergeron

  SSCrazy Eights

  Points: 8593

  More actions

  October 21, 2008 at 2:10 pm

  #887827

  I would love to know the answer for that, as the damned architect decided to change the exporting method, and export as Unicode now, 😉

  If anyone has the answer, or another way to do this.

  Thanks,

  J-F

  Cheers,

  J-F