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.
PS.
This is table structure in DDL:
CREATE TABLE tabRxBinder (
id INTEGER PRIMARY KEY AUTOINCREMENT
UNIQUE
NOT NULL,
tipo INTEGER NOT NULL,
regex TEXT NOT NULL,
chave TEXT NOT NULL);
And this is the code that queries it:
Dim filename As String = "\\myserver\myfolder\mydatabase.db3"Dim
connectionstring = String.Format("Data Source='{0}';Version=3;",
filename)Dim conn as System.Data.Common.DbConnection =
New SQLite.SQLiteConnection(connectionstring) With
{.ParseViaFramework = True}Dim dt as New DataTableUsing comm =
conn.CreateCommand
comm.CommandText = "SELECT * FROM tabRxBinder ORDER BY tipo, chave;"
Dim rdr As Data.Common.DbDataReader
conn.Open
rdr = comm.ExecuteReader
dt.Load(rdr)
conn.CloseEnd Using
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
