DanRz Posted May 8, 2023 Share Posted May 8, 2023 Hey, I am developing an small app that will add data to a mySQL database. This is working fine however, I need to encrypt the data. I have the code to do this; however, I am not sure how people structure the mySQL tables for this? Obviously, something like varchar(255) might not be long enough. So do you set all columns to be TEXT? Is there a better way of doing this? Thanks Dan Quote Link to comment https://forums.phpfreaks.com/topic/316272-mysql-structure-for-encrypted-data/ Share on other sites More sharing options...
Solution Barand Posted May 8, 2023 Solution Share Posted May 8, 2023 VARCHAR columns aren't limited to 255 characters From manual (https://dev.mysql.com/doc/refman/5.7/en/char.html) ... Quote Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 65,535. The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. Quote Link to comment https://forums.phpfreaks.com/topic/316272-mysql-structure-for-encrypted-data/#findComment-1608190 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.