Warning: #1265 Data truncated for column mysql

Question

db version: 10.1.35-MariaDB

charset: utf8

I was getting error: Specified key was too long; max key length is 767 bytes so I changed column length to 255. But i need to allow varchar(1000) in column, so when I enter large data in db column it says: Warning: #1265 Data truncated for column

How can I allow large data?

'But i need to allow varchar(1000) in column,' - then it cannot be a key and you should read this https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes — P.Salmon, Jul 11 '19 at 07:19
See my list of [_5 workarounds for 767_](http://mysql.rjweb.org/doc.php/limits#767_limit_in_innodb_indexes) -- each has a caveat, so you have to decide which you can live with. — Rick James, Jul 12 '19 at 04:01

score 0 · Answer 1 · edited Jul 11 '19 at 07:14

0

Try making the column length max, then it will work

ALTER TABLE table_name
MODIFY COLUMN column_name datatype(MAX);

edited Jul 11 '19 at 07:14

Nicola Ambrosetti

2,567
3
22
38

answered Jul 11 '19 at 06:47

Ramana Sakhavarapu

132
7

1

mysql does not have datatype(MAX) construct. – P.Salmon Jul 11 '19 at 07:18

score 0 · Accepted Answer · answered Jul 11 '19 at 18:07

0

Thanks to @P.Salmon.

The column length restriction is only for keys. All other columns can have any length.

answered Jul 11 '19 at 18:07

Irfan Y

1,242
2
21
68

Warning: #1265 Data truncated for column mysql

2 Answers2