Home Forums SQL Server 2014 Administration - SQL Server 2014 Disable Unicode output RE: Disable Unicode output

  • July 29, 2014 at 8:09 pm

    #1733441

    michael_alawneh (7/28/2014)

    I am running SQL Server 2012. I have been producing files as output for the Unix folks at work. We are running into an issue with what appears to be all the files I produce are using Unicode and placing hidden characters in the beginning of files. I am simply using "Results to File" as the option vs going to grid/text.

    The data being exported is not in Unicode data types.

    When viewed in UltraEdit hex mode I see "0" or "EF BB BF".

    The solution I have been using to get around this is taking the file open it in Notepad and do a Save As with Encoding = ANSI from the dropdown.

    Any help on just creating the file in ANSI from the get go would help.

    Thanks.

    Are you saving it as a .rpt file?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)