Re: [PHP-DEV] Mysql result data types

2017-10-12 Thread li...@rhsoft.net
Am 12.10.2017 um 17:16 schrieb Johannes Schlüter: On Do, 2017-10-12 at 14:55 +0300, Reinis Rozitis wrote: Hello, is there a reason (technical or historical) why the data coming from MySQL is always strings? I've found only one case where the data type is "honored" - PDO+mysqlnd+emulation off

Re: [PHP-DEV] Mysql result data types

2017-10-12 Thread Johannes Schlüter
On Do, 2017-10-12 at 14:55 +0300, Reinis Rozitis wrote: > Hello, > is there a reason (technical or historical) why the data coming from > MySQL is always strings? > I've found only one case where the data type is "honored" - > PDO+mysqlnd+emulation off [1] The reason for this is that this is the

RE: [PHP-DEV] Mysql result data types

2017-10-12 Thread Reinis Rozitis
> who forces you to ext/mysql? It's out of topic but obviously the code/software and products on the servers. For me as a system administrator I have choice either to never upgrade (for example https://w3techs.com/technologies/details/pl-php/all/all one can see the rough rate of php version

Re: [PHP-DEV] Mysql result data types

2017-10-12 Thread li...@rhsoft.net
Am 12.10.2017 um 14:34 schrieb Reinis Rozitis: no idea what the state of PDO is http://blog.ulf-wendel.de/2008/php-new-network-traffic-cpu-and-memory- savings-with-mysqlnd/ if(mysqli_options($this->conn, MYSQLI_OPT_INT_AND_FLOAT_NATIVE, Thanks, as we still partly (forced to) live in

RE: [PHP-DEV] Mysql result data types

2017-10-12 Thread Reinis Rozitis
> no idea what the state of PDO is > > > http://blog.ulf-wendel.de/2008/php-new-network-traffic-cpu-and-memory- > savings-with-mysqlnd/ > >if(mysqli_options($this->conn, MYSQLI_OPT_INT_AND_FLOAT_NATIVE, Thanks, as we still partly (forced to) live in the "deprecated or moved to pecl"

Re: [PHP-DEV] Mysql result data types

2017-10-12 Thread li...@rhsoft.net
Am 12.10.2017 um 13:55 schrieb Reinis Rozitis: is there a reason (technical or historical) why the data coming from MySQL is always strings? I've found only one case where the data type is "honored" - PDO+mysqlnd+emulation off [1] not entirely true, our database-layer acts directly with

[PHP-DEV] Mysql result data types

2017-10-12 Thread Reinis Rozitis
Hello, is there a reason (technical or historical) why the data coming from MySQL is always strings? I've found only one case where the data type is "honored" - PDO+mysqlnd+emulation off [1] We made a fairly simple patch to 'mysqlnd' which enables (configurable via ini) data to be returned