Re: Help - variable removing leading "0" in stored procedure

[John Constantine]

Sorted!!!

The problem isn't with the procedure at all.....

It was my own fault,

When calling the procedure I WAS doing this :

mysql> call P1(01234567890)//
+------------+
| @x |
+------------+
| 1234567890 |
+------------+
1 row in set (0.00 sec)

The answer was to explicitly specify the data, like so :

mysql> call P1('01234567890')//
+------------+
| @x |
+-------------+
| 01234567890 |
+-------------+
1 row in set (0.00 sec)

I triggered onto this when I did a selct on the original variable "p" within the procedure, and saw that no matter what I did it still got passed without the 0, so the user variable was never going to work.

Still, got there in the end.

Thanks

JC