How to export text file by xp_cmdshell for Thailand Language

Hariharan Krishnamoorthi

9y2.3k

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hariharan Krishnamoorthi9y ago
Finally, I got the solution for this question.

In the bcp command we need to put -w instead of -c.

For supporting other languages, we need to set this as [-w wide character type].

Please see the below. Its work fine for me.

QUERY
SELECT @FilePath='D:\CustomerReports\Customers.txt'

SELECT @Command = 'bcp "SELECT * FROM "' + @dbname + '".dbo.tblCustomer(nolock)" queryout ' +@FilePath+ ' -S' + @@servername + ' -T -w -t "" '

EXEC master..xp_cmdshell @Command
Manish Kumar9y ago
Open you file Customers.txt

goto File>> Save As>> In Encoding drop down select unicode and save.
Hariharan Krishnamoorthi9y ago
Hi Manish,
How to save the file as unicode by using the above command.

Thanks
Hari
Manish Kumar9y ago
May be file was not saved as Unicode
Please save the file as unicode.