Insert a blank space using datainsert
1 次查看(过去 30 天)
显示 更早的评论
Hi all,
I am changing over from fastinsert to datainsert and I am having an issue inserting blank spaces to my SQL table.
Ex: a = {''};
Old code (works): fastinsert(conn,tableName,fieldNames,a);
New code (doesn't work): datainsert(conn,tableName,fieldNames,a);
datainsert treats the blank character as empty, and inserts a NULL value to the table. Is there a way to force it to intrepret this as a blank character instead?
Thanks!
0 个评论
采纳的回答
Madhav Rajan
2015-7-21
I understand that you are trying to insert a black space into an SQL table using the "datainsert" function.
The "datainsert" function automatically casts the string '' which is of type MATLAB 'char' to NULL prior to the insertion. One workaround for this issue is to use the string representation in Java as shown in the following example:
Suppose I have a MYSQL table called "names" with three fields 'id', 'name' and 'subject'. I want to insert a record with the 'name' column's value to be '' (the empty string), I would do the following:
>> colnames = {'id','name' , 'subject'};
>> data = {13, java.lang.String(''),'asd'};
>> datainsert(conn,tablenames,colnames,data)
Hope I have answered your question.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!