void RequetteBDD::add(Files::Fichier file)
{

    string query = "INSERT INTO files(titre,url,type,txt,lastcrawl) VALUES (?,?,?,?,?)";

    sql::PreparedStatement  *prep_stmt;

    prep_stmt = con->prepareStatement(query);

    prep_stmt->setString(1,file.getNom()); //title
    prep_stmt->setString(2,file.getURL().getUri()); //url
    prep_stmt->setInt(3,file.getTypeInt()); //type

    //i also try :
    istringstream stream(file.getTextFull());
    prep_stmt->setBlob(4,&stream);
    //but the saved length was exactly the same.

    prep_stmt->setString(4,file.getTextFull()); //here is the probleme

    prep_stmt->setInt(5,time(NULL)); //timstamp

    prep_stmt->execute();
    delete prep_stmt;

}

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT ,
  `titre` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(1) NOT NULL DEFAULT '0' COMMENT ,
  `txt` longtext COLLATE utf8_unicode_ci NOT NULL,
  `lastcrawl` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;