On 14/03/2011 09:26, Bruce Wen wrote:
If indeed necessary to insert one control character, you need insert the int value (ASCII code) of the control character, I think. Of course, the column's data type should be int or tinyint.
No, it's a control character embedded in a string. I've ended up having to define a function in Java to convert an int to a char for lack of a better idea, but I'm amazed that there isn't a built-in function for this. ------------------------------------------------------------------------ John English | My old University of Brighton home page is still here: | http://www.it.brighton.ac.uk/staff/je ------------------------------------------------------------------------