![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
http://philip.greenspun.com/sql/limits.html
"...if you thought that these limitations were bad, you haven't gotten to the
big one: the Oracle SQL parser can only handle string literals up to 4000
characters in length. SQL*Plus is even more restricted. It can handle
strings up to 2500 characters in length. From most Oracle clients, there
will in fact be no way to insert data longer than 4000 characters long into
a table. A statement/system that works perfectly with a 4000-character
string will fail completely with a 4001-character string. You have to
completely redesign the way you're doing things to work with strings that
might be long."
Can anyone explain what possible security or performance benefits Oracle had in mind when setting the 4000 char limit? Because it seems very retarded.
"...if you thought that these limitations were bad, you haven't gotten to the
big one: the Oracle SQL parser can only handle string literals up to 4000
characters in length. SQL*Plus is even more restricted. It can handle
strings up to 2500 characters in length. From most Oracle clients, there
will in fact be no way to insert data longer than 4000 characters long into
a table. A statement/system that works perfectly with a 4000-character
string will fail completely with a 4001-character string. You have to
completely redesign the way you're doing things to work with strings that
might be long."
Can anyone explain what possible security or performance benefits Oracle had in mind when setting the 4000 char limit? Because it seems very retarded.
