Re: insert the + character in a char or varchar column
Fred van Engen <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi, On Wed, Aug 06, 2003 at 09:22:43AM +0000, Phil Guiol wrote: > I have a problem regarding the + character. It seems that I can't insert > it in a char or varchar type column. It's suprising, considering that all > of the other mathematic operators are inserted perfectly. Could you show your MySQL query? UPDATE mytable SET myfield = 'abcd+fgh' Should just store the value 'abcd+fgh' literally (without quotes). > I tried using the ASCII type ALT+43, but ALT 4 is apparently an automatic > web function to escape the page. > Is the problem in typing the + in a webform or is it a problem when typing it in the MySQL client? It seems you're using a webform. What software do you use for processing the form? Could you show some code? A + is used in URL encoded strings for a space character. Maybe this is what's happening in your situation? Often the browser and server side software take care of that. > I am not sure whether it's a bug or not, but I would greatly appreciate it > if I could get an answer on this matter. > It should work just fine. This seems more like a scripting error than a MySQL bug (so this is the wrong list I guess). Regards, Fred. -- Fred van Engen XB Networks B.V. email: [email protected] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]