Why a warning? NULL has a meaning that cannot be represented in other ways. A missing death_date means that you John is alive. death_date=NULL means that we don't know when John has died. Representing an information in the only correct way should not cause a warning. Redards Federico -------------------------------------------- Mar 3/2/15, Roberto Spadim <roberto@spadim.com.br> ha scritto: Oggetto: Re: [Maria-discuss] Restated: JSON cannot represent binary data A: "Federico Razzoli" <federico_raz@yahoo.it> Cc: "Justin Swanhart" <greenlion@gmail.com>, "Tom Worster" <fsb@thefsb.org>, "maria-discuss email list" <maria-discuss@lists.launchpad.net> Data: Martedì 3 febbraio 2015, 20:45 back to the question What *should* COLUMN_JSON() do when a dynamic column contains BINARY values? today what should be expect? return "wrong" (incompatible with json specs) json value? return null+warning? return "wrong"+warning? i think it's a 'sql_mode' that should be set to strict or not