Difference between binary and character datatype in MySQL? with examples and limitation

Question

What is the difference between binary and character datatype in MySQL? need examples and limitation info

Then start by looking at the documentation.

Gordon Linoff
– Gordon Linoff

2016-08-29 10:19:03 +00:00
Commented Aug 29, 2016 at 10:19 — Gordon Linoff
– Gordon Linoff, Commented Aug 29, 2016 at 10:19

Community · Accepted Answer · 2017-05-23 12:22:53Z

3

The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they contain binary strings rather than nonbinary strings. That is, they contain byte strings rather than character strings. This means that they have no character set, and sorting and comparison are based on the numeric values of the bytes in the values. for more details

http://www.tutorialspoint.com/mysql/mysql-data-types.htm

http://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html

and also read

MySQL "binary" vs "char character set binary"

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Aug 29, 2016 at 10:23

Abhishek

3791 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Difference between binary and character datatype in MySQL? with examples and limitation

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related