1
Vote

BCP failed if table name contains Japanese characters

description

Tryign to migrate one of my databases to SQL Azure yet it failed with the below,
 
SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'example.dbo.???'.
 
bcp.exe "[example].[dbo].[得意先]" out "c:\SQLAzureMW\BCPData\dbo.得意先.dat" -E -n -T -S myserver
 
Has anyone seen this before?

comments

ghuey wrote Jun 18, 2011 at 2:31 PM

Hi, Did you try this BCP command from a command window? I want to be sure that I rule out SQLAzureMW. It sounds like a bug with BCP. If you want, contact me offline (via Codeplex) and send me a simple TSQL script of your table so I can reproduce.

Regards,
George