I was doing more experimenation and finally got the text return right.

What I did was first terminate the returned text string using the
sqllen parameter, then trim.

I was acustomed to other database engine API return null terminated
string upon fetch so I was not expecting this.

Now I need to play with timestamp next.

jml