469,106 Members | 2,353 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

UDFs in Mysql


I have written a few UDF functions to run on mysql server (linux),
they seem to work pretty well although I notice one problem.

Say for example I have a table called t with 2 columns c1 and c2.

If I do : UPDATE t set c2 = udf-function-name(c1)

everything appears to work ok, however c1 has been inadvertantly
changed, it has a null character (0 byte) added to the end of it,
viewable if you do :

select hex(c1) from t (got the normal string plus 2 extra 00's on
the end).

Anyone know why this is happening / how to cure it?

I thought it was because I was null terminating the parameter passed
through to c but it still does this when i dont do this.

Any help appreciated.


Jul 20 '05 #1
0 870

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Eugene | last post: by
3 posts views Thread by David Carver | last post: by
reply views Thread by Fan Ruo Xin | last post: by
reply views Thread by Helmut Tessarek | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.