char VS nchar

[accessman2]

Hi,

char: fixed-length character data with a maximum length of 8000 characters.
nchar: fixed-length unicode data with a maximum length of 4000 characters.

I have a question, from above 2 datatypes, except the length is different, what is main difference between them?

can anybody list an example for that?

table1:
Name char => amy
Name2 nchar=> amy

I don't know what 's the difference?

Please let me know,thanks.

 

[pdx_man]

Look up what Unicode is. A brief explanation is that it is an expanded character set able to store the additional characters used in all the character for the different languages.

Char = 8 bit length
NChar = 16 bit length