Skip to Content.
Sympa Menu

freetds - [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 AT lists.ibiblio.org
  • Subject: [freetds] sql parameters truncated to 80 char
  • Date: Sat, 26 Jun 2010 11:28:58 -0500

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'




Archive powered by MHonArc 2.6.24.

Top of Page