PureBasic Forums - English

I have develop a small program that access an Access Database, in the table there are fields which are Memo Fields.

I store the field in a String variable, when retrieving the data out of the memo fields with texts of more than 255 chars the result that I'm having is that the variable contains only 255 chars the rest are truncated.

Do you have experienced this problem? If so what I'm doing wrong.

Thanks in advance.

Are you sure the string is not stored as truncated in the database?

There is no hardcoded limit in GetDatabaseString() with v4, so it should handle any size.

Access limits strings (text) to 255. Memo type fields allow longer strings.

That's right. Memo can have longer values, but they are not working correctly with GetDatabaseString(). I had some problems in the past (I used PB 3.94) and I solved the problem, by splitting the strings into a few 255 char fields and put them together into one string, after receiving data from database.
If you use MySQL, you would not have this problems, I think. So it sounds to me, that it has something to do with Access.

I dont have any problems with MEMO type and long strings. could you please give an example of your problem? It is maybe intressting for other DB app coders.

Hello Tranquil,

Here you have an example:

2303,„ƒ„ƒ‚„ƒ„„‚„„„„ƒ„…„ƒ„…ƒƒ‚‡„‚ƒ……ƒƒƒ‚‚„ƒ‚‚‚ƒ

You're not dealing with any null characters in there, are you?

Hello Xombie,

No, I'm not dealing with NULL chars. If is there any ascii 0, I escape to ascii 255

I will try this @work monday. thanks for fast answer.