Why 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)?

MathWorks Support Team

2009 6 27

1 个回答

回答已采纳

14 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

Follow Question

采纳的回答

MathWorks Support Team 2009-6-27

在 MATLAB Online 中打开

0 个投票

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) = ' ';