Hi All,
I am trying to export customer table records to text file by using xp_cmdshell.
But when customer records are in Thailand language, the out put comes with undefined characters like '?????????) '
QUERY
SELECT @FilePath='D:\CustomerReports\Customers.txt'
SELECT @Command = 'bcp "SELECT * FROM "' + @dbname + '".dbo.tblCustomer(nolock)" queryout ' +@FilePath+ ' -S' + @@servername + ' -T -c -t "" '
EXEC master..xp_cmdshell @Command
Please how to resolve to display the charaters as thailand language.