Post reply

text data type question

  • January 10, 2008 at 8:23 am

    #178088

    Hiya,

    having a table for storing Terms&Condition texts (for storing multiple whitelabel terms&cond.), so wondering which data type would be better for storing the terms text itself.Should be nvarchar(max) or text?????We are using MS SQL 2000, but possibly will migrate to 2k5.

    Thanks

    Ben

  • January 10, 2008 at 8:32 am

    #766686

    Benjamin Kovac (1/10/2008)

    Hiya,

    having a table for storing Terms&Condition texts (for storing multiple whitelabel terms&cond.), so wondering which data type would be better for storing the terms text itself.Should be nvarchar(max) or text?????We are using MS SQL 2000, but possibly will migrate to 2k5.

    Thanks

    Ben

    Hi Ben,

    SQL Server 2000 has only support for text. If you move to 2005, then on 2005 you can use nvarchar(max). Internally they are stored the same way, but it is much easier to modify the contents of nvarchar(max) columns.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • January 10, 2008 at 8:35 am

    #766689

    Thanks Andras,

    At the moment it looks we are going to stick with MSSQL 2000, but will change in short time.Anyway thanks for your quick reply. I should say-koszi szepen:)

    Ben

  • January 10, 2008 at 8:37 am

    #766691

    Benjamin Kovac (1/10/2008)

    Thanks Andras,

    At the moment it looks we are going to stick with MSSQL 2000, but will change in short time.Anyway thanks for your quick reply. I should say-koszi szepen🙂

    Ben

    Szivesen,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply