Re: sql parameters truncated to 80 char
chad phillips <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
running cpan i DBI gives me: Strange distribution name [DBI] Bundle Bundle::DBI (TIMB/DBI-1.611.tar.gz) Module < DBI (TIMB/DBI-1.611.tar.gz) I believe I am running freetds-0.82. What is the best way to check that for sure? thanks chad On Sat, Jun 26, 2010 at 12:09 PM, Frediano Ziglio <[email protected]>wrote: > Which dbi driver are you using? Which FreeTDS version? > > Frediano Ziglio > > Il giorno 26/giu/2010, alle ore 18.28, chad phillips < > [email protected]> ha scritto: > > Hi, >> >> When I run a select against MSSQL, my sql parameters get limited to 80 >> characters. I am trying to run a query against a varchar(250) field, buy >> my >> parameters get cut off at 80 characters. >> >> I am using FreeTDS on a linux box to connect to MSSQL. We are using perl. >> The protocol is set to 8.0. I ran profiler and trapped the sql that is >> sent. In the sql you can see where it sets the field to varchar(80) >> instead >> of varchar(250). >> >> Any suggestions on how I can fix this? >> >> thanks >> chad >> >> DECLARE @p1 INT >> SET @p1 = NULL >> EXEC sp_prepare @p1 OUTPUT, N'@P1 varchar(80)', >> N' >> SELECT distinct >> ses_title, >> ses_code, >> ses_start_date, >> ses_start_time, >> ses_end_time, >> lrm_name >> >> >> FROM dbo.ev_event >> JOIN dbo.ev_session ON evt_key = ses_evt_key >> AND ses_delete_flag = 0 >> AND evt_code = ''ASA2010'' >> JOIN dbo.ev_session_ext ON ses_key = ses_key_ext >> LEFT JOIN dbo.client_aafp_m09_cme_session ON ses_m09_key_ext >> = m09_key >> LEFT JOIN ev_event_session_room ON esr_ses_key = ses_key >> LEFT JOIN ev_event_location_room ON lrm_key = esr_lrm_key >> LEFT JOIN ev_event_location ON evl_key = lrm_evl_key >> left join ev_location (nolock) on loc_key = evl_loc_key >> LEFT JOIN dbo.ev_session_track_type ON ses_set_key = set_key >> where >> ses_title = @p1 >> order by ses_start_date, ses_start_time >> ', 1 >> select @p1 >> EXEC sp_execute 1, 'Cardiac Arrhythmias (including atrial >> fibrillation): >> A Brief Review of Cardiac Arrhythmias' >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > _______________________________________________ > FreeTDS mailing list > [email protected] > > http://lists.ibiblio.org/mailman/listinfo/freetds >