View Single Post
  #1  
Old 05-05-2006, 06:17 PM
beaugirl beaugirl is online now
Registered User
 
Join Date: 05-05-2006
Posts: 2
SQL Output to File foreign character problem

Hello -- I have a step where I run some SQL and Output to File. Some of characters I output have accents and such. When I run the very same SQL script in Query Analyzer with "output to file" it is correct. However, when I run the SQL using VBP, the output has various replacement characters. In both cases, the resulting file is ANSI. Is there any way to correct this?
Reply With Quote