I have recently discovered that mysql only allows 256 charcters in each field. What is the best way around this for storing a news database with 257+ charcters? Any suggestions.I dont know mysql but what you say is simply not true. Read up or use google to find a way to change the data type eg. in Access you can have "memo" and then change the input boxes in the HTML to the amount you want eg: 2000.well yes in mysql it is true. but to by pass it you have to have your datatype as "text" or mediumtext
then you can save upto 65000 characters.CHAR = 255 characters (max, fixed-length)
VARCHAR = 255 characters
TINYTEXT = 255 characters
TEXT = 65535 characters
MEDIUMTEXT = 16777215 characters
LONGTEXT = 4294967295 charactersScoutt, I think what Johan meant when he said
I dont know mysql but what you say is simply not true
was exactly what you replied with. That there is a way to store the data that BA needed, he just needed to switch the data type.
He was just saying that mySQL must have a way to store that length of text, he just wasn't sure like.
then you can save upto 65000 characters.CHAR = 255 characters (max, fixed-length)
VARCHAR = 255 characters
TINYTEXT = 255 characters
TEXT = 65535 characters
MEDIUMTEXT = 16777215 characters
LONGTEXT = 4294967295 charactersScoutt, I think what Johan meant when he said
I dont know mysql but what you say is simply not true
was exactly what you replied with. That there is a way to store the data that BA needed, he just needed to switch the data type.
He was just saying that mySQL must have a way to store that length of text, he just wasn't sure like.