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 <guillermopol...@gmail.com
> 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 <
> norb...@linuxnetworks.de> 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
>> libopendbx-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
>> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>>
>
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
