Срд, 07 Июл 2010, Denis Samson писал(а):
>
> Bill, I tried a ddins with M$ SQL Server 2008 R2, and it works...
> So our culprit really seems to be the MySQL ODBC driver!
>
> I'll be using my workaround (build a comma-delimited file and LOAD FILE it
> into
> MySQL) until they release the next version which presumably has the bug fixed,
> or debug my way into the driver...
their database engine is good but the odbc driver is very bad.
Good luck!
>
>
> ]lh=:'select hnd,id,lat,lon from stop';,.each 1 2;('un';'deux');1234
> 1235;2345 2345
> ┌───────────────────────────────┬─┬──────┬────┬────┐
> │select hnd,id,lat,lon from stop│1│┌────┐│1234│2345│
> │ │2││un ││1235│2345│
> │ │ │├────┤│ │ │
> │ │ ││deux││ │ │
> │ │ │└────┘│ │ │
> └───────────────────────────────┴─┴──────┴────┴────┘
I think that should be
]lh=:'select hnd,id,lat,lon from stop'; 1 2;(>'un';'deux');1234 1235;2345 2345
shape of numbers doesn't matter but string data must not boxed, may be
that is the reason for the funny characters returned.
--
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
