Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Answers
How to export text file by xp_cmdshell for Thailand Language
Hariharan Krishnamoorthi
7y
303
1
Reply
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.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Get Data using Joins in sqlserver
Remove Extra Space between string in whole column