SQL Server Performance

"N" before string value

Discussion in 'General Developer Questions' started by Akthar, Sep 29, 2005.

  1. Akthar New Member

    hi all,

    Why SQL adds "N" before a string value in query analyzer, i read something on UNICODE based characters!

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  2. dineshasanka Moderator

  3. Akthar New Member

    It this compulsory, does it make a difference in the query execution time?

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  4. dineshasanka Moderator

  5. Madhivanan Moderator

    I think better to use N to specify that they are NVarchars

    Madhivanan

    Failing to plan is Planning to fail
  6. FrankKalis Moderator

    quote:Originally posted by Akthar

    It this compulsory, does it make a difference in the query execution time?

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
    Since unicode data occupies twice the space nun-unicode data does it might very well make a difference. Use it only when you have to.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  7. Akthar New Member

    ok... Thanks all

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS

Share This Page