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.

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
_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

varchar & varchar2

Questions by Category