7 messages in org.perl.dbi-usersRe: "max" datatypes support of SQL Se...
FromSent OnAttachments
Fumiaki YoshimatsuMar 13, 2006 6:44 pm 
Steve SapovitsAug 21, 2006 6:27 am 
mich...@bnpparibas.comAug 21, 2006 6:30 am 
Steve SapovitsAug 21, 2006 6:38 am 
mich...@bnpparibas.comAug 21, 2006 6:51 am 
Steve SapovitsAug 21, 2006 7:01 am 
Steve SapovitsAug 21, 2006 7:00 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: "max" datatypes support of SQL Server 2005 for DBD-ODBCActions...
From:mich...@bnpparibas.com (mich@bnpparibas.com)
Date:Aug 21, 2006 6:51:49 am
List:org.perl.dbi-users

There is no configuration that can be done at the DBD::Sybase level for the BLK handling - if you are limited to 255 chars then it is most likely a limitation of the BLK api implementation of FreeTDS.

Michael

Extranet stev@comcast.net - 21/08/2006 15:39

To: Michael PEPPLER

cc: fumiakiy, dbi-users

Subject: Re: "max" datatypes support of SQL Server 2005 for DBD-ODBC

mich@bnpparibas.com wrote:

DBD::Sybase will support whatever the underlying client libs are capable of handling.

I'll throw the wrench in now: I'm using the DBD::Sybase bulk copy interface as well. That's working great but I'm getting a failure on a table that has a varchar(max) column. I haven't isolated it to that yet -- I'm going to test with and without that. In the meantime, if you have any knowledge to bestow on me regarding varchar(max) and bulk copies, let me know.

This is a RH Linux environment, FreeTDS drivers. Perl 5.8.7, DBD::Sybase 1.07. Target database is MS SQL Server 9.0.2047.

Bulk loading rocks by the way Michael. ;-)

Michael

Extranet stev@comcast.net - 21/08/2006 15:27

To: fumiakiy

cc: dbi-users

Subject: Re: "max" datatypes support of SQL Server 2005 for DBD-ODBC

Fumiaki Yoshimatsu wrote:

I had a need to support [n]varchar(max) and varbinary(max) datatypes of MS SQL Server 2005, and patched DBD-ODBC. Below is the diff from the current svn.

Does anyone know what, if any, support for these DBD::Sybase has?

-- Steve Sapovits stev@comcast.net

This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie.