Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (https://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   SQL Output to File foreign character problem (https://www.kinook.com/Forum/showthread.php?t=1727)

beaugirl 05-05-2006 06:17 PM

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?

kinook 05-08-2006 02:58 PM

Add

-u

to the 'Additional command-line options' on the Server tab of the Run SQL action to cause OSQL to generate a Unicode (UTF-16) file.

beaugirl 05-08-2006 03:22 PM

That works, thank you!


All times are GMT -5. The time now is 04:58 AM.


Copyright © 1999-2023 Kinook Software, Inc.