0
[
  "module" => "Audio"
  "description" => "2021-08-04/1628067947.39.wav"
  "conversation_id" => null
  "audiotags" => "[{"tag":"Tag some body","id":6,"start":"6.0","end":"6.1","attributes":{"label":"Tag some body"}}]"
]

Hello I need to add 'audiotags' column in a table in json format. even try varchar(1000) not saving

sorry for my english

$channels_input['audiotags'] = $input['audiotags'];
$channel_data = Channel::create($channels_input);

NB: using Mysql8

Jason Polydor
  • 75
  • 1
  • 8
  • 2
    VARCHAR max length is 255. use TEXT (or JSON type on newer versions) – Gert B. Aug 05 '21 at 13:47
  • Does this answer your question? [MySQL: Large VARCHAR vs. TEXT?](https://stackoverflow.com/questions/2023481/mysql-large-varchar-vs-text) – miken32 Aug 05 '21 at 15:08
  • See also https://stackoverflow.com/questions/13506832/what-is-the-mysql-varchar-max-size – miken32 Aug 05 '21 at 15:08

0 Answers0