PDO的native_type的列表getColumnMeta（） [英] List of PHP native_type's for PDO getColumnMeta()

问题描述

我使用PDO数据库抽象库来确保我的代码是可移植的。但是，现在我发现我需要列信息，所以我转向 PDOStatement-> getColumnMeta（）方法希望它会有些标准化 - 但从我发现它实际上似乎是开放的。

I am using the PDO Database Abstraction library to make sure my code is portable. However, I now find that I need column information so I turned to the PDOStatement->getColumnMeta() method hoping it would be somewhat standardized - but from what I have found it actually seems open-ended.

例如，当调用该方法从SQLite它似乎你得到一组可能的值：

For example, when calling that method from SQLite it seems you get one set of possible values:

http://gcov.php.net/PHP_5_3/lcov_html/pdo_sqlite/sqlite_statement.c.gcov.php

null
double
blob
string
integer
...

来自MySQL数据库的调用列出了所有其他奇怪的值：
http://gcov.php.net/PHP_5_3/lcov_html/pdo_mysql/mysql_statement.c.gcov.php

While a call from the MySQL database lists all kinds of other weird values: http://gcov.php.net/PHP_5_3/lcov_html/pdo_mysql/mysql_statement.c.gcov.php

var_string
longlong
newdecimal
geometry
...

我可能也在错误的地方，但我只是找不到任何有用的数据

I may be looking in the wrong place also, but I just can't find any useful data on what "native_type" values can be when it comes to switching around databases.

推荐答案

这是PDO的其中一个领域

This is one of those areas of PDO that was left intentionally undefined, in order to keep the abstraction light weight.

PDO没有为这个方法定义类型的标准表示法;每个驾驶员都有自己的想法，它可以返回这里。

PDO does not define a standard representation of types for this method; each driver has it's own idea about what it can return here.

这篇关于PDO的native_type的列表getColumnMeta（）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！