CODEWITHSUNDEEP
c#asp.netmysqlsqlsql-server
bot
bot

Reputation: 4921

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

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. :)

Upvotes: 0

Views: 154

Answers (1)

RandomSeed
RandomSeed

Reputation: 29809

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.

Upvotes: 1

Related Questions