Can I configure codepage / encoding for captured output

Can I configure codepage / encoding for captured output

2
NewbieNewbie
2

    Sep 26, 2008#1

    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

    262
    MasterMaster
    262

      Sep 26, 2008#2

      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)

      2
      NewbieNewbie
      2

        Sep 26, 2008#3

        @jorrasdk

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

        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