CODEWITHSUNDEEP
mysqlsqldatabaseblobvarchar
Zoolander
Zoolander

Reputation: 2363

How to convert VARCHAR to BLOB in MySQL?

I need to convert a MySQL column to use BLOB instead of VARCHAR that's used to store encrypted data.

I can find all sorts of posts of how to convert from BLOB to VARCHAR, but cannot find anything for going from VARCHAR to BLOB.

Can someone tell me how to do this?

Upvotes: 5

Views: 5760

Answers (1)

Zoolander
Zoolander

Reputation: 2363

I figured it out by using:

alter table users change email email blob

Upvotes: 8

Related Questions