The following are some differences of Non-Unicode and Unicode data which stores in SQL Server.
| Non-Unicode | Unicode |
|---|---|
| Char (size) - Data Type | nChar (size) - Data Type |
| Varchar (size/max) - Data Type | nVarchar (size/max) - Data Type |
| Text - Data Type | nText - Data Type |
| Stored as Localized Data | Stored as Globalized Data |
| It supports English Language | It supports all National Languages |
| It can store 1 byte per 1 character | It can store 2 bytes per 1 character |
| Example : e character in English language you need Non-Unicode and costs 1 byte (4 bits) to store in Data Base | Example : è character in Japaness Or Chinese language you need Unicode and costs 2 bytes (8 bits) to store in Data Base |
Comments