Re: [opendbx] String truncated error on ODBC

[Guillermo P. <gui...@gm...>]

Ok, finally I'm getting into the Windoze world and trying to solve this
:).  The truncation seems to be a buffer problem.

Whay I'm looking is that the types length described in
http://msdn.microsoft.com/en-us/library/bb677267.aspx does not fit with the
length in odbc_priv_collength.

>From the odbc docs I assume the right lengths for datetimes are more like

        case SQL_DATE:
        case SQL_TYPE_DATE:
            return 11;
        case SQL_TIME:
        case SQL_TYPE_TIME:
            return 9;
        case SQL_TIMESTAMP:
        case SQL_TYPE_TIMESTAMP:
            return 24;

I've checked the latest sources with and without the fix and it works fine
with my changes.

Can we add them? :)
Guille


On Fri, Jul 15, 2011 at 2:41 PM, Guillermo Polito <gui...@gm...
> wrote:

> What puzzles me is that the insert is successful and I can execute querys
> from the SQL management studio and they work.
>
> I'll try inserting a value like that.
>
> Thanks!
>
>
> On Fri, Jul 15, 2011 at 9:35 AM, Norbert Sendetzky <
> no...@li...> wrote:
>
>> Hi Guille
>>
>> > Create table test4 (fechia datetime)
>> > insert into test4 values(''10-10-10'')
>> >
>> > select * from test4  ->  [Microsoft][ODBC SQL Server Driver]String data,
>> > right truncation
>> >
>> > ¿Is it a known issue?
>>
>> No, no that I'm aware of, but your value is wrong. Can you try
>> '2010-10-10 00:00:00'?
>>
>
>
>> Norbert
>>
>>
>> ------------------------------------------------------------------------------
>> AppSumo Presents a FREE Video for the SourceForge Community by Eric
>> Ries, the creator of the Lean Startup Methodology on "Lean Startup
>> Secrets Revealed." This video shows you how to validate your ideas,
>> optimize your ideas and identify your business strategy.
>> http://p.sf.net/sfu/appsumosfdev2dev
>> _______________________________________________
>> libopendbx-devel mailing list
>> lib...@li...
>> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
>> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>>
>
>