SQLFetch and TEXT fields on MySQL

[Aerisarn]

Hi, I got the following problem. When i try to select a Text field on a MyISAM table of my DB, I can only fetch the first 1024 bytes of the resultset. If the TEXT field exceeds 1024 bytes, I fetch nothing. Here is the the dump on nwnx_odbc log:

...
o Got request: SELECT dialog FROM quest_main WHERE quest_id='q_goblin'
o Sent response (0 bytes):
o Got request: SELECT dialog FROM quest_main WHERE quest_id='q_goblin'
o Sent response (1023 bytes): <init>
...

Between the two queries I obviously changed the text field (truncated to 1023 bytes). Am i doing something weird? My current specs are:

Ubuntu Edgy with vanilla mysql 5 from the distro packages.
nwnx 2.7-beta4 (which is supposed to dinamically allocate resultsets, so i see no reason why it stops on 1024 bytes)
latest ODBC2 driver

I receive no error from nwnx nor odbc, please help

[MaxRock]

I just ran into the same problem *bump*

[Asparius]

Did you try to increase size of NWNX!ODBC!SPACER variable?...

[Fireboar]

[Quixsilver]

Interesting idea. nwnx_files is Windows only though, right?

[ShaDoOoW]

[Fireboar]

In that case, I would split it up into multiple rows on the database. Example table structure (very general PseudoSQL):

ITEM:
ItemID PRIMARY KEY
ItemName
ItemRecords

ITEM_RECORD:
RecordNo
ItemID
Text
PRIMARY KEY (RecordNo, ItemID)

[MaxRock]

if it's just plain text, you could set is as description of an item and store that.