White space instead of empty string from SQL Server database

Question

I have this query :

$this->dbSQLServer->select("nom, '' AS prenom")
                  ->from("users");

return $this->dbSQLServer->get()->result_array();

But instead of returning me '' for the prenom, I end up with ' '.

Any ideas where the problem might come from?

mega6382 · Accepted Answer · 2017-11-23 14:43:49Z

1

Try the Following instead:

$this->dbSQLServer->select("nom, Null AS prenom")
                  ->from("users");

Instead of empty string use Null

answered Nov 23, 2017 at 14:43

mega6382

9,39217 gold badges52 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1