問題描述
我使用 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
...
我也可能找錯了地方，但我找不到關于切換數據庫時native_type"值可能是什么的任何有用數據.
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 getColumnMeta() 的 PHP native_type 列表的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！