By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

Convert Character Sets On Export

P: 72
Hi,

Can I do a bulk "find and replace" on data in SQL Server to convert character set data?

I have data coming in from multiple external sources. That data is not always in UTF-8 or ASCII character sets, but that's okay internal to the database, as it has to remain in the source's local format.

Every month I run a query to select data out of the database, put it into a temporary export table, then dump it out to a plain text file.

The problem is that the destination of this plain text file is a legacy system that does not understand anything outsie the standard ASCII table. I occasionally send data that contains a handful of characters outside the normal character range it can understand.

I have a small program I wrote that can identify and find these characters once the text file is produced, but it's then a pain to go through and manually alter them.

I wondered if there was some ability within SQL Server to force data into a particular character set?

Regards,
Rob.
Jun 16 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.