String max length?

[Morpheus]

Does nwnx4 impose any maximum length restrictions on strings retrieved from the database?

Going to do some tests now, but wanted to fire off a quick question about it.

Morph

[Morpheus]

Yeah, in 1.07 it seems to truncate text coming back from the db. The datatype is 'text' and issuing the SQL in mysql client returns the entire string.

I guess its cap'd at 255 or something?

Morph

[Papillon]

There are two functions GetData and GetDataText. The former retrieves exactly strlen(sSmalColSpacer) (=128) at max, the latter retrieves 8*strlen(sSmalColSpacer) at max (from the top of my head). If you need more, then either enlarge the SmallCollSpacer constant, or enlarge the for-loop in GetDataText.

In 1.08, there wil be a 65K limit per column, which is set at compile time (i.e. it can be set abitrarly large if the need arises).
_________________
Papillon

[Morpheus]

Ahh, ok. I wasn't aware of the latter function. Sounds like its what I need.

thanks Papillon!