Difference between dataType binary(1632) in SQL Server and dataType binary(255) in MYSQL?

Question

I'm trying to change my server from SQL Server to MYSQL Server. I just wondering what's the difference between the two binary(1632) in SQL and binary(255) in MYSQL. I wanted to know because it could affect the data that I am going to insert in the database.

binary(1632) = is the max value of binary in SQL Server

binary(255) = is the max value of binary in MYSQL

Thank you in advance. :)

Besides the obvious, that values may be truncated if you try to insert them in a smaller field? Besides, SQL Server's maximum binary field size is 8000 — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jul 19, 2013 at 9:22

RandomSeed · Accepted Answer · 2013-07-19 09:24:28Z

1

Obviously, this has to do with the maximum size of the data the field is able to contain. If you really need the column be able to contain 1632 bytes of data, use the BLOB MySQL type instead.

answered Jul 19, 2013 at 9:24

RandomSeed

29.9k6 gold badges54 silver badges91 bronze badges

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

3 Comments

bot Over a year ago

so the equivalent of binary(1632) in sql is a blob(1632) in mysql?

RandomSeed Over a year ago

I am not very familiar with SQL Server, but this is very likely to be -- although there is no such thing as BLOB(n) in MySQL, you cannot limit the size of a BLOB field, AFIK.

bot Over a year ago

thanks, I take this as an option. I try to find more for other possible solution.

Collectives™ on Stack Overflow

Difference between dataType binary(1632) in SQL Server and dataType binary(255) in MYSQL?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related