Can I configure codepage / encoding for captured output

[handyjan]

Hi,

I am setting up UltraEdit to query a MSSQL 2005 database, using sqlcmd.exe from the tools configuration.

I am able to get the query running, and also I can capture the output to a new file. It seems however, that the output encoding or codepage differs from the one I see, when i fire the command in a DOS box. I need UltraEdits output window to return output, using the same codepage / encoding I use from my system locale (Windows 1252 Danish).

I have tried multiple approaches, like setting the codepage/locale in the advanced menu, but I have had no luck so far.

Can anyone help me with this?

Thank you in advance.
Jan

[jorrasdk]

I have no one time solution to offer, but my workaround to get the encoding fixed whenever I have captured from DOS output into Windows is to use the UE convert:

File - Conversions - OEM to ANSI

(this way I get my captured Danish letters æøåÆØÅ back into readable form)

[handyjan]

@jorrasdk

Thanks for the advice, sometimes "the obvious" is a good solution

The slightly more persistent solution could perhaps be to record a macro that fires the sqlcmd tool and then makes the conversion. I will look into that.

Thank you!

Jan