To unicode or not to unicode ?

  • As I understand it, if your setting up a field to hold say a customer name, you should use varchar istead of nvarchar, as the first has less memory demands. Unicode is to be used when the text my have special characters in the text data ?

    Is these correct test for unicode variable use ?

  • Are you going to be storing any information in double byte languages - Chinese, Japanese etc. If so then these columns should be 'n'. If not and there is no chance of it being changed in the future use then don't bother. Also I am unsure that unicode uses more memory - just more bytes in the row so you have less row space available

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

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