Skip to Content.
Sympa Menu

freetds - Re: [freetds] sql parameters truncated to 80 char

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: chad phillips <chad AT chadphillips.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] sql parameters truncated to 80 char
  • Date: Sat, 26 Jun 2010 22:16:08 -0500

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 <freddy77 AT gmail.com>wrote:

> Which dbi driver are you using? Which FreeTDS version?
>
> Frediano Ziglio
>
> Il giorno 26/giu/2010, alle ore 18.28, chad phillips <
> chad AT chadphillips.org> 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
>> FreeTDS AT lists.ibiblio.org
>>
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
>
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page