Unable to retrieve field which has more than 255 chars

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Unable to retrieve field which has more than 255 chars by Anonymous Monk on Mar 07, 2012 at 08:02 UTC
show your code, turn on trace level	[reply]
Re^2: Unable to retrieve field which has more than 255 chars by Anonymous Monk on Mar 07, 2012 at 09:37 UTC
This is my code: my $dbiConn="DBI:Sybase:server=$prop{dbHost}:1433"; my $db=DBI->connect($dbiConn,$prop{dbUser},$prop{dbPwd}); my $sqlSt="select FilesTransfered,transactionDate from CDProcessTransaction where processname = '$prop{process}'"; my $recordSet=$db->prepare($sqlSt); $recordSet->execute( ); while (my @rValue=$recordSet->fetchrow_array) { print OUT "Files: @rValue\n"; } If length of field "FilesTransfered" is more than 255 characters, its truncated. This field contains the filenames processed (sometimes upto 20 filenames where it exceeds more than 255 chars) .	[reply]
Re^3: Unable to retrieve field which has more than 255 chars by choroba (Cardinal) on Mar 07, 2012 at 09:59 UTC
What is the type of the field? (I.e. show us how the table is created.)	[reply]
Re^3: Unable to retrieve field which has more than 255 chars by JavaFan (Canon) on Mar 07, 2012 at 10:20 UTC
f length of field "FilesTransfered" is more than 255 characters, its truncated. Sure, but not on retrieval. It means you're trying to stuff more than 255 characters in a field that doesn't allow more. It's like putting 100 pairs of socks in a drawer that only fits 20. You cannot get more than 20 pairs of socks out of them, the other 80 will have dropped on the ground. Change the type of column, and repopulate the table. Note that this isn't a Perl issue. It's a database issue, and you'll have this problem regardless of the language you're using to access the database.	[reply]
Re^3: Unable to retrieve field which has more than 255 chars by remiah (Hermit) on Mar 07, 2012 at 12:02 UTC
I am not sure for DBI:Sybase, but there could be some trouble with 255 characters. 1. driver and other version problem(TDS? I found http://comments.gmane.org/gmane.comp.db.tds.freetds/7075 2. explicit bind_param http://www.perlmonks.org/?node_id=491253 3. DBI's LongReadLen http://search.cpan.org/~timb/DBI-1.618/DBI.pm#LongReadLen I tested to fetch long field with MS Access's memo field (DBI::ADO). 1000byte. I thought I see the same trouble once before with MS Access(may that be a dream of mine?). But it returns long field fine on windows without explicit bind_param nor setting LongReadLen... It was just fine. I forget where I saw the same situation. Sorry for uncertain information.	[reply]
Re^4: Unable to retrieve field which has more than 255 chars by Anonymous Monk on Mar 07, 2012 at 12:40 UTC
Re: Unable to retrieve field which has more than 255 chars by CountZero (Bishop) on Mar 07, 2012 at 10:37 UTC
Did you double-check that indeed this field actually contains more than 255 chars? CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James My blog: Imperial Deltronics	[reply]
Re^2: Unable to retrieve field which has more than 255 chars by Anonymous Monk on Mar 07, 2012 at 11:43 UTC
I checked in backend and got the desired results. Actual length is 320 chars and I can retrieve them using the same query in mssql. Field datatype is defined as "nvarchar(2500)"	[reply]