Re: Sybase DATE and TIME data types

Thanks,
  did patches yesterday. See
https://github.com/FreeTDS/freetds/commit/235019b7342cea9bd200e7a7b00bb1bc26e37096
and https://github.com/FreeTDS/freetds/commit/526c035f66cc297943690fd4096444921a764206.

Is not easier to do a diff?

Currently only ODBC is missing to the list.

Frediano


2015-09-14 9:19 GMT+01:00  <[email protected]>:
> I've found one file I modified which wasn't in my document... sorry about that.
>
> The change is to include/sybdb.h, around line 154:
>
> enum
> {
>         SYBCHAR = 47,           /* 0x2F */
> #define SYBCHAR SYBCHAR
>         SYBVARCHAR = 39,        /* 0x27 */
> #define SYBVARCHAR      SYBVARCHAR
>         SYBINTN = 38,           /* 0x26 */
> #define SYBINTN SYBINTN
>         SYBINT1 = 48,           /* 0x30 */
> #define SYBINT1 SYBINT1
>         SYBINT2 = 52,           /* 0x34 */
> #define SYBINT2 SYBINT2
>         SYBINT4 = 56,           /* 0x38 */
> #define SYBINT4 SYBINT4
>         SYBINT8 = 127,          /* 0x7F */
> #define SYBINT8 SYBINT8
>         SYBFLT8 = 62,           /* 0x3E */
> #define SYBFLT8 SYBFLT8
>         SYBDATETIME = 61,       /* 0x3D */
> #define SYBDATETIME     SYBDATETIME
>         SYBDATE = 49,           /* 0x31 */
> #define SYBDATE         SYBDATE
>         SYBTIME = 51,           /* 0x33 */
> #define SYBTIME         SYBTIME
>         SYBBIT = 50,            /* 0x32 */
> #define SYBBIT  SYBBIT
>         SYBBITN = 104,          /* 0x68 */
>
> I'll keep looking in case there's anything else.....
>
> Cheers,
>
> Matthew.
> September 13 2015 12:19 PM, "Matthew"  wrote:Thanks for the kind words. It seems I must have missed something as
> datacopy is working for me when copying DATE and TIME columns from ASE
> 15.7 to ASE 15.7.
>
> A lot of what I did was trial and error and I tried to remember to leave
> a comment so I could find what I'd changed in order to write it up at
> the end.
>
> Any idea which file I would have changed to get it working with dblib?
> If not I'll untar the package somewhere else and run a find and diff to
> see if I can spot it.
>
> Cheers,
>
> Matthew.
>
> On 13/09/15 11:55, Frediano Ziglio wrote:
>  2015-09-11 10:04 GMT+01:00 :Dear All,
>
> I'm not really a C programmer (or C++ for that matter) but I wanted to be able to use datacopy
> tocopy tables with DATE and TIME data types. So, I decided to have a crack at adding them to
> FreeTDS.My testing has been successful, although I'm not sure the way I've coded it is correct so any
> help/fixes would be appreciated.
>
> I've attached a rich text document with the details. The first part proposes a quick and dirty
> fix,while the second is my best guess at the "correct" way of doing things.
>
> Bare in mind that this is currently only for Sybase to Sybase. I'm going to look at doing this
> forSQL Server too but that's a bit more complicated!
>
> Cheers,
>
> Matthew.
>
> Patch and effort are really appreciated.
> So appreciated that I already pushed some changes and is actually
> testing deeply (but I don't think there will be any regression).
>
> datacopy still does not work as SYBDATE/SYBTIME are not supported by
> dblib (you added support for libTDS not upper libraries and datacopy
> is based on dblib).
>
> Currently converting from string will use datetime format in all
> cases. ODBC has its standard so format strings are well defined for
> it.
>
> I added some improvements too based on previously patches on some other types.
>
> Yes, adding a new type in FreeTDS is really a nightmare !!!
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> [email protected] (mailto:[email protected])
> http://lists.ibiblio.org/mailman/listinfo/freetds (http://lists.ibiblio.org/mailman/listinfo/freetds)
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds