Monday, March 2, 2009

DIfference between varchar and nvarchar in Oracle

varchar2(20 char) means you can store 20 characters -- whereas varchar2(20) means you can store 20 bytes. the varchar2(20 char) might take 20, 40, 60, 80 or more bytes to hold a string. The maximum length of a varchar2 is still 4000 bytes so varchar2(4000 char) is "misleading" in that the field will max out at 4000 bytes -- not 4000 characters.

1 comment:

jahliajager said...

Casinos Near Casinos, Hotels & Casinos - MapYRO
Search for Casinos Near Casinos in Las 고양 출장마사지 Vegas, NV, United 구미 출장마사지 States. 수원 출장안마 Find popular Arts & Entertainment, Casinos 강원도 출장마사지 & Hotels nearby, 청주 출장안마 ranked by TripAdvisor members and

search engine

Custom Search