Inserting value to a database not working...

I have the following code which works perfectly but for the 'pix' field.

My code is:

mydir = 'E:\matlab\pet_dog\';

fid=fopen('E:\matlab\ratio for pet_dog.txt','wt');

allentries = dir(mydir);

diridxs = [allentries.isdir];

alldirs = allentries(diridxs);

allfiles = allentries(~diridxs); 

for ctr = 1:length(allfiles)

      x = fullfile(mydir, allfiles(ctr).name);

      pix = double(nnz(edge(rgb2gray(imread(x))))); 

      %disp(pix);

      ratio = fix(9600/pix);

     logintimeout(5);    

    con = database('fetchDB', '', '');

   ping(con);

   exdata = {'9600',pix,'-',ratio,x};

   colnames = {'imgSize', 'imgPixel', ' imgPart','ratio','imgName'};

   fastinsert(con, 'animal', colnames, exdata)

   close(con);

end

Output is: http://s21.postimg.org/75die2dxz/problem.png

Why the field 'imgPixel' is not showing the numerical values properly? What should I do?

Answer 1

[Walter Roberson]

Seems to me that is going to depend upon the schema you defined for the imgPixel column in the "animal" database. If it was previously defined as character, then it would stay as character until you changed the schema or deleted the database.

[Sayak]

ohhhh, yes yes. My database attribute datatype is character. So is the problem. Thanks. :-)