On Fri, Jan 27, 2017 at 12:58 PM, Antonio Carlos Jorge Patricio <
antonio...@gmail.com> wrote:
> I have a table in a SQLite 3 database file (.db3), which has a TEXT column
> whose fields often can be 1024 chars long or more.
>
> My application connects to this file using SQLite.NET library (from Nuget)
> and runs a simple "SELECT * FROM tabRxBinder;" command to populate a
> DataTable object.
>
> Inside this DataTable, all strings belonging to that column are truncated.
> In my tests, they got almost all chopped at 255 chars long, and just one
> was 270 chars long, but also truncated.
>
> I googled and found some people struggling with similar problems, but
> couldn't find a solution. Can anyone help me on this?
>
> Thank you very much.
>
>
I'm guessing this is a problem with SQLite.NET, or .NET itself, which is
not supported here. I am not a Windows literate developer. I run SQLite on
Linux and don't have any problem with >255 characters: example
SQLite version 3.14.2 2016-09-12 18:50:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table testit (testtext text);
sqlite> insert into testit(testtext)
values('11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111112');
sqlite> select * from testit;
11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111112
sqlite> select length(testtext) from testit;
401
sqlite>
--
There’s no obfuscated Perl contest because it’s pointless.
—Jeff Polk
Maranatha! <><
John McKown
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
