varchar & varchar2

hii,

What is the difference between varchar & varchar2?

View Answers

October 28, 2010 at 4:29 PM

hello,

varchar2 and varchar both are support strings,

but varchar2 support alphanumeric string.and another one difference the total byte of the data type are differ.









Related Tutorials/Questions & Answers:
varchar & varchar2
varchar & varchar2  hii, What is the difference between varchar & varchar2?   hello,ADS_TO_REPLACE_1 varchar2 and varchar both are support strings, but varchar2 support alphanumeric string.and another one
difference between varchar & varchar2?
difference between varchar & varchar2?  What is the difference between varchar & varchar2
Advertisements
ModuleNotFoundError: No module named 'django-postgres-unlimited-varchar'
ModuleNotFoundError: No module named 'django-postgres-unlimited-varchar' ...: ModuleNotFoundError: No module named 'django-postgres-unlimited-varchar' How to remove the ModuleNotFoundError: No module named 'django-postgres-unlimited-varchar'
Reply - Java Beginners
VARCHAR(100) PWDFFAMNT3 Number(10) PWDFFPURP4 Varchar2(100) PWDFFAMNT4 Number... USERCODE NUMBER(10) POSTDATE DATE FORMID VARCHAR2(20) LOCATIONID VARCHAR2(20) YRENDING NUMBER(10) REGNO VARCHAR2(20) LICENUMOFFACT VARCHAR2(50) SECT2Mi
foreign key error in sql
foreign key error in sql  create table matchdetails(mid varchar2(10),mdate date,team1 varchar2(10),team2 varchar2(10), stadium varchar2(10),city varchar2(10),mom varchar2(10),primary key(mid,mdate
runtime error:Invalid column name
NUMBER(5) PSTARTDATE VARCHAR(20) PENDDATE VARCHAR(20) SQL> desc EMS... VARCHAR2(50) TOPICDESC VARCHAR2(150) SQL
Oracle - JDBC
control instead of the system. REPORT1 { id varchar2(5), name varchar2(25), description varchar2(1000), data BLOB } REPORT2 { id varchar2(5
Writing a trigger for an userdefined datatype
the following columns DATATYPE :ADDRESS VARCHAR2(136) V_CODE VARCHAR2(8) T_CODE VARCHAR2(4) D_CODE VARCHAR2(2) PIN NUMBER(6) PHONE VARCHAR2(11) NOw I ill
Processing stored procedure in MySQL - SQL
in number, inv_name1 out varchar2,inv_name2 out varchar2, inv_name3 out varchar2, inv_name4 out varchar2, inv_name5 out varchar2, inv_name6 out varchar2, inv_name7 out varchar2,inv_name8 out varchar2,inv_name9 out varchar2,inv_name10 out varchar2
SQL Alter Table
TO vendors; - Add Column ALTER TABLE supplier ADD ( supplier_name varchar2(50), city varchar2(45) ); - Modifiy Column ALTER TABLE supplier MODIFY ( supplier_name varchar2(100) not null, city varchar2(75) ); - Drop
Database
Database  Suppose i have created a table BOOKSHELF create table BOOKSHELF (Title VARCHAR2(100) primary key, Publisher VARCHAR2(20), CategoryName VARCHAR2(20), Rating VARCHAR2(2), constraint CATFK Foreign Key (CategoryName
jsp - Development process
jsp  table is as follow Usr_id varchar(7) Unchecked Usr_fname varchar(20) Unchecked Usr_mname varchar(20) Unchecked Usr_lname varchar(20) Unchecked Usr_email varchar(50) Unchecked Usr_res_phone varchar(20) Unchecked Usr
hi - SQL
NOT NULL VARCHAR2(20) PHONENO NUMBER VILLAGE VARCHAR2(15
Data types in a table
:- VARCHAR2, CHAR, NUMBER, RAW, DATE, LONG and LONG RAW.   hello,,ADS_TO_REPLACE_2 These are the data types in table:- VARCHAR2, CHAR, NUMBER, RAW
error log
Name: error_process columns: sno number int_name varchar2(40) err_descri varchar2(400
error log and send Database
-------------- Table Name: error_process columns: sno number int_name varchar2(40) err_descri varchar2(400
Upload and display image and text records using JSP and Oracle
help me!! This is the table i have : RECORD: rollno: varchar2(20) name: varchar2(20) image blob Please help.. Need it urgently!! Thanks in advance
jsp code for dynamic time table generation - JSP-Servlet
`btech` ( `days` varchar(255) default NULL, `1` varchar(255) default NULL, `2` varchar(255) default NULL, `3` varchar(255) default NULL, `4
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
_NAME" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER
JSP - JSP-Servlet
` ( `days` varchar(255) default NULL, `1` varchar(255) default NULL, `2` varchar(255) default NULL, `3` varchar(255) default NULL, `4
project - JDBC
, `firstname` varchar(40) default NULL, `lastname` varchar(40) default NULL, `username` varchar(40) default NULL, `password` varchar(40
database connectivty
and designation are displayed how it is possible in jsp employee->(Ename varchar(30),Address varchar(256),Designation varchar(32),DateOfJoining date,ContactNumber numeric(12),PANNumbernumeric(15),Emp_Id varchar(50) primary key
database connectivity using jsp code
->(Ename varchar(30),Address varchar(256),Designation varchar(32),DateOfJoining date,ContactNumber numeric(12),PANNumbernumeric(15),Emp_Id varchar(50) primary key)this is employee table schema in mysql adduser->(Emp_ID varchar(50),Ename
Database Connectivity Withe Oracle
Integer Empname Varchar Emp_desig Varchar EmpJDate Varchar Emp_Salary Numeric
Query for generating Stock Report Using MVC architecture in j2ee
tables with data is: WATCHMASTER { watchid varchar(30), watchname varchar(20), Price varchar(20), QuantityAvailable varchar(30) } WATCHORDER { Orderid varchar(30), Quantity varchar(30), OrderDate DATE } someone told me here we used nested
Database Design
) NOT NULL auto_increment, `language` varchar(15) NOT NULL, `question` varchar(800) NOT NULL, `ans1` varbinary(150) NOT NULL, `ans2` varchar(150) NOT NULL
Shifting txt file to database - Java Beginners
name varchar2 des varchar2 J_date timestamp b_date date   Hi
displaying employee records and their images problem - JSP-Servlet
_name varchar(50); last_name varchar(50); department varchar(50); salary int; job_title varchar(50); Thanks in anticipation
alter data type
alter data type  alter data type of subName column for subject table to varchar(40
how to create a table
how to create a table  create table tablename (name varchar(10),name varchar(10));   You have specified name field twice, so error occurs. Use the following query: create table tablename (name varchar(10),address
upload csv to mysql db using jsp upload
have a table with 8 cloumns.(MDN--varchar(30),Otafdate date,crt varchar(30),dmdn varchar(30),dname text,rmdn varchar(30),rname text,cluster text) please help me
Data needs to be gathered in XML file from the database (MySql) using JSP
TABLE AlbumCatalogue( id VARCHAR(10) NOT NULL, Band VARCHAR(60) NOT NULL, AlbumTitle VARCHAR(60) NOT NULL, Year VARCHAR(4) NOT NULL, ChartPosition VARCHAR(3) NOT NULL, Price VARCHAR(6) NOT NULL, Availability VARCHAR(4) NOT NULL
Creating a database
, s_name varchar(15) NOT NULL, f_name varchar(20) NOT NULL, dob date NOT NULL..., class1 varchar(5) NOT NULL, address
populating one dropdown box depending on the value of other using jsp
NOT NULL, INVENTORY_SOURCE CHAR, CITY_NAME VARCHAR(250), STATE_CODE VARCHAR(250), STATE_NAME VARCHAR(250), COUNTRY_CODE VARCHAR (250), COUNTRY_NAME VARCHAR (250
Sequence generator problem - JDBC
VARCHAR2(20), MATTER VARCHAR2(150), MATTERFILE VARCHAR2(30), STATUS VARCHAR2(20
sqllllllll - Java Beginners
contain the fields name and data type using oracle NAMEOFCONT=varchar2 NUMOFCONLABENG=Number CONPERFORMDATE=Date CONPERTODATE=Date PONUM=VARCHAR2 VALUE=NUMBER ESI=VARCHAR2 EPF=VARCHAR2 This is the table name ConDetailspopup Qry
Database Design
, `userid` varchar(40) NOT NULL default '', `password` varchar(40) NOT NULL...` ( `categoryid` int(11) NOT NULL auto_increment, `categoryname` varchar(60) default..., `storename` varchar(50) NOT NULL default '', `storeurl` varchar(50) NOT NULL