问题描述
ODBC 有两种主要的独立于开源平台的实现.它是 iODBC 和 unixODBC .
There are two major Open Source platform independent implementation of the ODBC. It is iODBC and unixODBC.
考虑将Unix作为ODBC用户平台和功能，这两种实现之间真正的实际区别是什么?
Considering Unix as ODBC user platform and feature-wise, what are the real practical differences between these two implementations?
推荐答案
就这样，您知道我使用unixODBC并对此做出了贡献，而我不使用iODBC.
Just so you know I use and have contributed to unixODBC and I don't use iODBC.
unixODBC遵循MS ODBC驱动程序管理器，并具有2字节UCS2编码的SQLWCHAR.我相信iODBC使用wchar_t(这是基于尝试在DBD :: ODBC中支持iODBC的基础)
unixODBC follows MS ODBC Driver manager and has SQLWCHARs as 2 bytes UCS2 encoded.iODBC I believe uses wchar_t (this is based on attempting to support iODBC in DBD::ODBC)
unixODBC有一个，我不认为iODBC有.
unixODBC has one, I don't "think" iODBC has.
许多ODBC应用程序都支持unixODBC，例如Oracle，IBM和SAP的OpenOffice和ODBC驱动程序.我不确定iODBC.
A lot of ODBC applications support unixODBC e.g., OpenOffice and ODBC drivers from Oracle, IBM and SAP. I'm not sure about iODBC.
自从Apple包含iODBC以来，iODBC一直是Mac上使用最多的工具(尽管我相信它已从Lion中删除).两者都可以从源代码构建，并且大多数Linux发行版都打包(尽管不是Novell/Suse发行版，后者仅发行unixODBC).
iODBC has always been the most used on on Macs since Apple included it (although I believe it is removed from Lion). Both can be built from source and most Linux distributions package both (although not Novell/Suse which only distributes unixODBC).
unixODBC是线程安全的，并且包含用于保护不同级别的句柄的标志. iODBC以前不是这种情况(但是现在可能已经改变了).
unixODBC is thread safe and includes flags to protect handles at different levels. This did not used to be the case with iODBC (but that might have changed now).
两个都有支持论坛(unixODBC有3个)，尽管我要说unixODBC的论坛要活跃得多(两个都在).
Both have support forums (unixODBC has 3) although I'd say the unixODBC ones are far more active (I'm on both).
unixODBC是GPL和LGPL.iODBC是LGPL/BSD
unixODBC is GPL and LGPL.iODBC is LGPL/BSD
在实践中并没有太大的区别，但是我认为您会发现unixODBC被更广泛地使用.
In practice there is not a lot of difference but I think you'll find unixODBC is more widely used.
这篇关于iODBC和unixODBC之间的功能区别是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！