[OpenSPP-project] String lengths in SPPP
Status: Planning
Brought to you by:
deanwillis
From: Dean W. <dea...@so...> - 2011-06-09 14:43:21
|
As the dev team understands the SPPP specs, most string lengths are unbounded. This is a problem for the use of MySQL as a persistence model, at least with Spring/JDBC, as the database schema gets fixed-size strings. Two questions: 1) What sizes are reasonable for each of the strings in the schema? 2) Do we need something in the protocol to inform the client of permitted string sizes and/or to add bounds-checking and reporting in the transaction logic? -- Dean Willis |