問題描述
我使用 PDO 數(shù)據(jù)庫抽象庫來確保我的代碼是可移植的.但是，我現(xiàn)在發(fā)現(xiàn)我需要列信息，所以我轉(zhuǎn)向 PDOStatement->getColumnMeta() 方法希望它會有些標準化 - 但從我發(fā)現(xiàn)它實際上似乎是開放式的.
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.
例如，當(dāng)從 SQLite 調(diào)用該方法時，您似乎得到了一組可能的值:
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 數(shù)據(jù)庫的調(diào)用列出了各種其他奇怪的值: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
...
我也可能找錯了地方，但我找不到關(guān)于切換數(shù)據(jù)庫時native_type"值可能是什么的任何有用數(shù)據(jù).
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 中有意未定義的領(lǐng)域之一，以保持抽象的輕量級.
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.
這篇關(guān)于用于 PDO getColumnMeta() 的 PHP native_type 列表的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！