freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] ntext 8000 char limit - still there?
- From: Randy Syring <randy AT thesyrings.us>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Cc: nem AT emptec.com
- Subject: Re: [freetds] ntext 8000 char limit - still there?
- Date: Thu, 14 Aug 2014 11:50:31 -0400
Have you seen this:
http://www.freetds.org/userguide/troubleshooting.htm#KNOWNISSUES
There is some info there about lengths for both varchar and text.
*Randy Syring*
Husband | Father | Redeemed Sinner
/"For what does it profit a man to gain the whole world
and forfeit his soul?" (Mark 8:36 ESV)/
On 08/14/2014 11:45 AM, Nem W Schlecht wrote:
Hello all,
I'm using FreeTDS with Perl and I'm trying to insert large chunks of
text into a table with an NTEXT field. My script runs and produces no
errors, but I'm only getting 8000 chars when I call
DATALENGTH(ntextfieldname) on the SQL side. I found a discussion on this
back from 2004 in the FreeTDS list where it said this was a limitation of
the protocol.
Is this still a limit? What is the accepted way of getting around this
limitation and inserting large-sized values into NTEXT fields?
My test code:
#!/usr/bin/perl
#CREATE TABLE testinsert (
# querytext NTEXT
#);
use DBI;
my @srvopts;
push(@srvopts, "server=MyServer");
push(@srvopts, "database=MyDatabase");
my $srv_opts_joined=join(';', @srvopts);
my $dbh = DBI->connect("dbi:Sybase:$srv_opts_joined", 'user', 'secret');
my $sth = $dbh->prepare("
INSERT INTO testinsert
(querytext)
VALUES (?)
");
my @words;
open(WORDS, "/usr/share/dict/words");
while (<WORDS>) {
push(@words, $_);
}
my $big = join('', @words);
print "L: ", length($big), "\n";
$sth->execute($big);
$sth->finish();
$dbh->disconnect();
#
# SELECT DATALENGTH(querytext) FROM testinsert;
#
-
[freetds] ntext 8000 char limit - still there?,
Nem W Schlecht, 08/14/2014
-
Re: [freetds] ntext 8000 char limit - still there?,
Randy Syring, 08/14/2014
- Re: [freetds] ntext 8000 char limit - still there?, Nem W Schlecht, 08/14/2014
- Re: [freetds] ntext 8000 char limit - still there?, Frediano Ziglio, 08/14/2014
-
Re: [freetds] ntext 8000 char limit - still there?,
Randy Syring, 08/14/2014
Archive powered by MHonArc 2.6.24.