[ruby-dbi-users] several issue

Kubo Takehiro kubo at jiubao.org
Fri Jul 8 20:53:50 EDT 2011


The DBI maintainers moved to RDBI <URL:https://github.com/RDBI/rdbi>.
I guess that they won't improve DBI anymore.

On Sat, Jul 9, 2011 at 12:11 AM, Oliver Peng <oliver.peng at skywave.com>wrote:

> Hi All:
>
> ****
>
> I found several issues after using DBI. Please have a look:****
>
> ** **
>
> For DATE column in MS SQL Server, the value in database is 2011-02-12 and
> what I get is 2011-02-1.****
>
> ** **
>
> For TINYINT column in MS SQL Server, DBI will convert value to Boolean type
> instead of number.****
>
> ** **
>
> For different date, timestamp columns, DBI will return different classes.
> Here is the table for all the classes which I got:****
>
> ** **
>
> Column type****
>
> MySQL****
>
> MS SQL Server****
>
> Oracle****
>
> DATE****
>
> Date****
>
> String****
>
> Time****
>
> TIME****
>
> DateTime****
>
> String****
>
> ** **
>
> DATETIME****
>
> DateTime****
>
> DateTime****
>
> ** **
>
> TIMESTAMP****
>
> DateTime****
>
> ** **
>
> Time****
>
> DATETIMEOFFSET****
>
> ** **
>
> String****
>
> ** **
>
> DATETIME2****
>
> ** **
>
> String****
>
> ** **
>
> SMALLDATETIME****
>
> ** **
>
> DateTime****
>
> ** **
>
> ** **
>
> It will be great if we can use unified interface for all these column
> types.****
>
> ** **
>
> Oliver****
>
> _______________________________________________
> ruby-dbi-users mailing list
> ruby-dbi-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/ruby-dbi-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://rubyforge.org/pipermail/ruby-dbi-users/attachments/20110709/91af36f8/attachment.html>


More information about the ruby-dbi-users mailing list