Does executeS() turn every value into a string?

[theillo]

I'm fetching some stuff from a DB, and it seems like every column is turned into a string, even if it's really an integer.

Am I doing something wrong?

 

$sql = 'SELECT * FROM `'._DB_PREFIX_.'mytable` WHERE id_assignment='.(int)$id_assignment.' ORDER BY position ASC'
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

 

[tdsoft]

Yes, what is your issue from this SQL?

[theillo]

It gives me string when I expect to get integers.

so $result['id_product'] will be "38" instead of 38.

Edited October 2, 2019 by theillo (see edit history)

[electriz]

On 10/2/2019 at 6:30 AM, theillo said:

It gives me string when I expect to get integers.

so $result['id_product'] will be "38" instead of 38.

So you can cast it as integer, for example: $idProduct = (int)$result['id_product'];

[theillo]

Of course, but it will require me to do this manually and I'll have to know which field has which type... 

So it's expected behavior of executeS() to turn every value into a string?