MSSQL Execute SQL - Unicode capable?

FinalBuilder Discussion
1

Hi all,

i use the MSSQL Exectute SQL action to retrieve translations for our setups.

The langauages used are, German, English and Japanese. I use a query and output the result to a file (Log behaves the same) and all japanese characters are replaced by “?”. Also the file encoding is set to ANSI (explaining the ?).

I tried using the Create Text file Action to create a UTF-8 file, this works, but the SQL Actions overwrites this.

Is there anything i can do?

Thanks
Holger

2

The documentation of sqlcmd  https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility states it is possible to use -u for unicode output, can i specify this somewhere in the action?

3

Ok i now help myself with writing the query to a textfile and using the “Execute Program” action to run sqlcmd.exe with the additional parameter -u (needs to be defined in addtion to -o for the output file)

So i get what i want, but now i have a different problem, on my development machine sqlcmd.exe is in a path A, while on the build server ist is in path B.

Can i read the configured path from finalbuilder?

Thanks
Holger

4

Got it!

FinalBuilder8.ini in %programdata%\VSoft\FinalBuilder8

5

Apologies for the slow response, been dealing with server issues today (bios upgrades broke our hyper-v cluster).

I will add an option for the unicode output file for the next update.

6
I will add an option for the unicode output file for the next update.


Cool, Thanks!
7

Hi, where is this options for manage unicode?
Thanks

8

It’s on the output tab under the output file name field.