Re: char() function

2002-04-08 Thread Benjamin Pflugmann
Hello. On Mon, Apr 08, 2002 at 11:24:56AM -0400, [EMAIL PROTECTED] wrote: [...] > still...I wonder why I got a 'Query OK, 1 row affected' message [...] > > insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); > > > > it seems to work initially...(Query OK, 1 row affected (

Re: char() function

2002-04-08 Thread Benjamin Pflugmann
PROTECTED] wrote: > Hi guys, > > Our java code blows up when we try to insert a string with a ';' > inside of it. So we tried to do a work-around by replacing ';' with > '||CHAR(59)||' to insert it, using the char function and the > character's res

RE: char() function

2002-04-08 Thread Don Vu
, 1 row affected' message -Don > -Original Message- > From: Don Vu > Sent: Monday, April 08, 2002 11:08 AM > To: MySQL Mailing List (E-mail) > Subject: char() function > > Hi guys, > > Our java code blows up when we try to insert a s

char() function

2002-04-08 Thread Don Vu
Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: in