Difference between Char/Varchar/Varchar2


Differences between CHAR varchar and varchar2:



CHAR(5) is fixed length, right padded with spaces.
VARCHAR(5) is fixed length, right padded with null
VARCHAR2(5) is variable length.
Thus the difference between VARCHAR and VARCHAR2 is that VARCHAR is ANSI standard but takes up space whereas VARCHAR2 is Oracle-only but makes more efficient use of space.
But as someone has already pointed out, Oracle have resolved this (in 9.2, maybe earlier) by casting VARCHAR to VARCHAR2.

Varchar and Varchar2 both are of variable character. Varchar can have MAximum 2000 character while Varchar can contain maximum 4000 character.
Varchar is of ANSI SQL standart while Varchar2 is of Oracle standard.

Comments

Post a Comment

Popular posts from this blog

How to configure Glowroot with Liferay

Image
 Dear Folks, First of all we need to know what is Glowroot and what can we get from it. Features Trace capture for slow requests and errors Continuous profiling (with very handy filtering) Response time breakdown charts Response time percentile charts SQL capture and aggregation Service call capture and aggregation MBean attribute capture and charts Configurable alerting Historical rollup of all data (1m, 5m, 30m, 4h) with configurable retention Full support for async requests that span multiple threads Responsive UI with mobile support Optional central collector Step 1: Download Glowroot from Official website and extract that zip into your drive (                     Like: C:\glowroot). Now open your Liferay workspace and in the Servers tab double click on your server and click on the Browse External properties button and write your glowroot file path with javaagent. (Ex:-  -javaagent:path/to/glowroot.jar) After that restart your Liferay server and your gloroot will start on default
Read more

How to Get Back Asus Zenphone 5 from Soft Brick

Image
Dear Folks, Very Warm Welcome, Now I'm Writing this post for those who have facing hard bricked problem in #AsusZenphone5. Before some days same problem i have faced and i was fully fade up with my phone and i go too many shops for  repairing the phone but they charged too much for this. then i decided too solve it. So when your phone is in USB Logo mode or Asus Logo Mode Then it's confirmed your phone has been bricked. So, let’s start! There are some files, please prepare to download :   IntelAndroidDrvSetup1.5.0.exe Asus USB Driver. Download  here  Asus Zenfone 5 RAW firmware. Download   here   xfstk-downloader-setup-1.5.1.exe   iSocUSB-Driver-Setup-1.0.4.exe Recovery Image. Download  here ADB + Fastboot. Download  here Instruction :  install above driver as per ranking. follow these instruction while installing: Right click on setup Select run as administrator  Note  : while installing isoc drive system may ask you to connect your device or resta
Read more

How to Unlock Boot Loader of Htc Explorer

Image
Download following files HTC Sync > Download Download A310E recovery > Download Superuser.zip > Download Steps to install recovery and root HTC Explorer  Remove the battery of yout phone and again insert the battery and press the volume key down+power button after some seconds your phone start in boot mode and plug the usb in your phone.    To root HTC Explorer, you first need to unlock the bootloader of it. open c:\ drive and make a android folder and extract A310E recovery on overthere To unlock the bootloader, visit this  and follow appropriate steps there. Open www.htcdev.com and register yourself Goto Bootloader  and HTC Explorer isn’t listed as working device there  but it has been tested and works perfectly. So, choose “ all other supported models ” when selected device -Click "Yes" to continue. -You must accept the legal terms here, basically its saying that: -HTC and your carrier are NOT responsible for your actions -You a
Read more