Post reply

Double byte (UTF-8)

  • June 21, 2005 at 9:25 pm

    #164690

    How can I upgrade the Datawarehouse DB in SQL Server to support double byte? Can somebody help me?

  • June 22, 2005 at 6:10 am

    #567354

    How do you mean support double byte?

    Maybe enough to look into NCHAR and NVARCHAR? Or maybe just a different COLLATION is enough?

  • June 23, 2005 at 2:03 am

    #567783

    You have to redefine your datatypes. Collation is not enough because if a column is defined char(8), varchar(8)... it means max. 8 single bytes (characters) will be stored regardless of the collation.

    If you define your column nchar(8) or nvarchar(8) then you will store 8 double bytes (16 bytes) there.



    Bye
    Gabor

  • June 23, 2005 at 3:01 am

    #567800

    Thanks guys!!! Your answers help me a lot!

  • June 23, 2005 at 10:07 am

    #567993

    Suggestion: This discussion should have been post in the Globalization forum.

    For further reference it is clearer.

    Regards,

    Carl

Viewing 5 posts - 1 through 5 (of 5 total)

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