Sql Problem

Miscellaneous Forums/General Discussion/Sql Problem


Maybe someone can help me out here..

I'm trying to load & save streams into an sql field (text). When I try reading the field, it ignores all char(0)'s.

something like:
Concat(char(10),char(0),char(5),char(6))

when read, returns:
10,5,6. rather than 10, 0, 5, 6

I have checked the length of the field in sql, and the 0-chars are still there, but when reading the field from blitzmax app, it's ignoring them.

This is one of the last steps for me to finish a huge portion of my project, so any quick tip would be greatly appreciated.



Ignore. Wrong place for this post

Brucey would probably know.

ps: this should be in a BMax forum.

What the...
I never noticed the new bruceys mod forum. My bad. thanks.

Ignore post.