answersLogoWhite

0


Best Answer

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

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the difference between text and varchar in mysql?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Algebra

What is the difference between a program and algorithm give examples in each?

Check your text book. The answer is there


What is the Difference between php hypertext pre-processor and hyper text mark uplanguage?

Well their is a quite big difference between them. a mark-up language um i wouldn't call it a actual programming language, to basic. It deals mostly with the visual aspects interface of a website, where php deals with the side server aspects, which process information which control the processing of information and data accross your a website etc... so i guess the main difference is... mark-up language is used to show the visual interface of a website, php is for functionality. i don't consider mark up languages as a actual true programming language


Text that is in excess of 255 characters of alphanumeric data can be entered into this data type.?

Short text


What is the difference between HTML and JSP?

HTML is client side. JSP is server side.HTML provides a means to describe the structure of text-based information in a document - by denoting certain text as links, headings, paragraphs, lists, and so on - and to supplement that text with interactive forms, embedded images, and other objects. HTML is written in the form of tags, surrounded by angle brackets. HTML can also describe, to some degree, the appearance and semantics of a document, and can include embedded scripting language code (such as JavaScript) which can affect the behavior of Web browsers and other HTML processors.The JSP syntax adds additional XML-like tags, called JSP actions, to be used to invoke built-in functionality. Additionally, the technology allows for the creation of JSP tag libraries that act as extensions to the standard HTML or XML tags. Tag libraries provide a platform independent way of extending the capabilities of a Web server. JSP is alot like php.


What is the answer to page 5.3 in punchline algebra book A?

Dog sled- Polar Coaster / Intestine- Taking An Exam / Educational television - Text Tube

Related questions

How to determine the MySQL leading prefix index size?

Indexes can be created that use only the leading part of column values, using col_name(length) syntax to specify an index prefix length. The MySQL prefix index is only apply to CHAR, VARCHAR, BINARY, VARBINARY, BLOB and TEXT columns.In order to determine the best MySQL leading prefix index size, you should try to find the smallest value size that gives uniqueness.


What is the name of the data type used to store long passages of data containing text and alphanumeric characters?

varchar


What is the difference between numbered text and multilevel numbered text?

1


What is the difference between copying text and moving text?

The difference between moving text and copying text is that when you move the text, it is gone from the original spot. When you copy text, the text also stays in the original spot and then also gets copied to a new spot.


Difference between number and text type field in ms access?

This is true in any database (Access, Oracle). A number field is technically called a "NUMERIC" field. Only numbers can be inserted into a field that has this designator. A text field is for characters or numbers. It can be a "CHAR" (character), a VARCHAR (characters or numbers). It's basically a way of putting rules on columns--what type of data belongs there.


What is the difference between an iMessage and a text?

It is blue


What is the difference between literature text and non literature text?

Literaure is short. Text is long.


What is an difference between numbered outline text and outline numbered text?

Hhhhhhhhgyui8


What is the difference between linear text and non linear text?

don't know


What does is the difference between highlighted text and a selected text?

There is no difference both are highlighted and selected.


What is difference between alter and modify on oracle?

MODIFY is a clause used within an ALTER statement, such as ALTER TABLE, ALTER INDEX or ALTER MATERIALIZED VIEW, etc. That is, MODIFY isn't a command by itself. For example, you might change the length of a text column in a table with the following: ALTER TABLE employee MODIFY (email_address VARCHAR(132));


What is the difference between formating the text and editing the text?

Formatting the text might include changing the style of it. Editing the text is changing the text only.