-6

What is the VARCHAR length in Sqlite ?

vp_arth
  • 14,461
  • 4
  • 37
  • 66
luyao
  • 27
  • 4
  • Welcome to Stack Overflow. Please spend some time taking the [tour] and reading through the [help] pages, particularly [ask], before your next post here. Good luck. – Ken White Sep 20 '17 at 00:52
  • Can you be more specific? Are you talking about `VARCHAR(##)` or something like https://sqlite.org/limits.html#max_length – aphrid Sep 20 '17 at 00:52

1 Answers1

2

Sqlite doesn't place an explicit limit on the length of the VARCHAR, however the maximum length of any string or blob is limited to the maximum length value, which is 1 billion by default.

You can increase or decrease this limit as well, though. So you're really only limited by the memory you have available.

Bricky
  • 2,572
  • 14
  • 30