Home Forums SQL Server 7,2000 Administration Differences between Unicode Text and ASCII text file RE: Differences between Unicode Text and ASCII text file

  • June 12, 2009 at 7:17 pm

    #1008967

    RBarryYoung (6/11/2009)

    Jeff Moden (6/10/2009)

    RBarryYoung (6/10/2009)

    What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.

    Any idea if SQL Server supports UTF-8?

    SQL Server? Nope.

    Though oddly enough, SSMS does (for at least one case).

    Heh... found it in BOL. SQL Server supports Unicode 3.2 and that doesn't unclude the UTF-8 standard. Thanks for the confirmation, Barry.

    --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)