answersLogoWhite

0


Best Answer

The former is for strings, the later is for numbers (integers).

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the difference between varchar and int?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Difference between char and varchar datatypes?

Char is fixed length, while Varchar is variable length.


What is the difference between varchar and nvarchar?

The difference between varchar and nvarchardatatypes is that Nvarchar stores UNICODE data. If you have requirements to store UNICODE or multilingual data, nvarcharis your choice. Varchar stores ASCII data and should be your data type of choice for normal use.


What is the difference between text and varchar in mysql?

That is text where we put only character type value and that is varchar where we put all data type value


What is the difference between int a and int a in C?

nothing


How do you create an application form using PHP?

CREATE TABLE `test`.`users` ( `id` INT NOT NULL auto_increment , `name` VARCHAR( 20 ) NOT NULL , `password` VARCHAR( 20 ) NOT NULL , `email` VARCHAR( 20 ) NOT NULL , PRIMARY KEY ( `id` ) )


What is the difference between varchar and char?

Varchar cuts off trailing spaces if given a shorter word than its declared length, while char does not. Char will pad spaces after it if given a shorter word.


What is the difference between int and int32?

The size (and value-range) of int is platform-dependent, whilst that of int32_t is fixed.


How do you use case and else condition update and insert in sql server stored procedure?

CREATE PROCEDURE SP_MENUMASTER_UPDATE( @PARENT_ID INT(3) ,@MENU_NAME VARCHAR(100) ,@UR VARCHAR(100) ,@USR VARCHAR(255) ,@I_D INT(3) ,@ifvalue VARCHAR(50) ) AS BEGIN CASE ifvalue WHEN "newuser" THEN UPDATE MENUMASTER SET USER=USR WHERE ID=I_D; ELSE UPDATE MENUMASTER SET PARENTID=PARENT_ID,MENUNAME=MENU_NAME,URL=UR WHERE ID=I_D; END CASE; END


How do you create a table in Microsoft SQL?

create table tb (id int primary key, name varchar(10) not null, age int) tb - name of the table


What is the Difference between normal int and regular int?

Are you sure that these words (normal int and regular int) actually mean something?


What is the difference between declaration and initialization?

Perhaps an example will help. extern int value; /* declaration */ int value; /* definition */ int value= 20; /* definition with initialization */


What is the difference between Variable and Data Type of Variable?

Let's look at an example. int a = 1; Here our variable is 'a' which is of type 'int'