SQLlite big string column question

[Rook Zimbabwe]

Lets say I had a string of about 3000 characters and I wanted to save it to a column of a table in a SQLlite DB... Does anyone know what COLUMN type that should be?

[netmaestro]

VARCHAR should be fine.

[Kiffi]

Lets say I had a string of about 3000 characters and I wanted to save it to a column of a table in a SQLlite DB... Does anyone know what COLUMN type that should be?

one of the great benefit of SQLite is creating typeless columns.
In short: Leave the colum type empty and it will store data of any size.

Code: Select all

Create myTable (myColumn)

Greetings ... Kiffi

[Marco2007]

one of the great benefit of SQLite

If I only had known about all those benefits three years ago

[Edwin Knoppert]

Oh well the documentations was on three years ago ( www.sqlite.org )
Anyway, typeless s***s anyway..
Programmers need restrictions to fix their code and prevent/reduce bugs.
Strong typed is the way to go.

[Kiffi]

Programmers need restrictions to fix their code and prevent/reduce bugs.

this is your opinion, not mine.

Greetings ... Kiffi

[srod]

Aye, some programmers might need restrictions... not me however!

[Rook Zimbabwe]

It looks like SQLLite automatically truncates the line... I cannot tell however because the BLOB code that writes the tiles into the DB is not working...

[Kiffi]

It looks like SQLLite automatically truncates the line...

no truncation here:

Code: Select all

UseSQLiteDatabase()

DB = OpenDatabase(#PB_Any, ":memory:", "", "", #PB_Database_SQLite)

DatabaseUpdate(DB, "Create Table myTable (myColumn)")

DatabaseUpdate(DB, "Insert Into myTable (myColumn) Values ('" + Space(  1000) + "')")
DatabaseUpdate(DB, "Insert Into myTable (myColumn) Values ('" + Space(  5000) + "')")
DatabaseUpdate(DB, "Insert Into myTable (myColumn) Values ('" + Space( 10000) + "')")
DatabaseUpdate(DB, "Insert Into myTable (myColumn) Values ('" + Space(100000) + "')")

DatabaseQuery(DB, "Select * From myTable")

While NextDatabaseRow(DB)
  Debug Len(GetDatabaseString(DB, 0))
Wend

Greetings ... Kiffi