MATLAB: Does the INSERT function generate an error when the character string I am trying to insert contains NULL characters in the Database Toolbox 3.0.1 (R14SP1)

charactercharactersdatabaseDatabase Toolboxerrorinsertnullzero

I am trying to use INSERT to insert a character string containing NULL (ASCII 0) characters. This causes INSERT to produce an error specific to the database I am using.

Best Answer

The Database Toolbox's INSERT function cannot be used to insert character strings that include the NULL character (ASCII 0). As a workaround, the NULL characters can either be removed or set to space characters, as in the following examples:
% remove null characters from character array "insert_data"
idx = find(insert_data == 0);
insert_data(idx) = [];
% set the null characters in character array "insert_data" to space characters:
idx = find(insert_data == 0);
insert_data(idx) = ' ';