How to export text file by xp_cmdshell for Thailand Language

Apr 5 2017 10:38 AM
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. 
 
 

Answers (4)