char VS nchar (1 Viewer)

accessman2

Registered User.
Local time
Yesterday, 22:55
Joined
Sep 15, 2005
Messages
335
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

Just trying to help
Local time
Yesterday, 22:55
Joined
Jan 23, 2001
Messages
1,347
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
 

Users who are viewing this thread

Top Bottom