Re: insert the + character in a char or varchar column

Phil,

Phil Guiol wrote:
> Hello,
> 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.
> I tried using the ASCII type ALT+43, but ALT 4 is apparently an 
> automatic web function to escape the page.

Web problems are off-topic in [email protected]

MySQL itself has no problems with storing/retrieving plus sign as well as any 
other character.

mysql> insert into t values('ab+cd');
Query OK, 1 row affected (0.00 sec)

mysql> select * from t;
+-------+
| t     |
+-------+
| ab+cd |
+-------+


> 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.

Not MySQL bug.

> Thank you,
> Philippe Guiol

-- 
  Are you MySQL certified? -> http://www.mysql.com/certification
  For technical support contracts, visit https://order.mysql.com/?ref=msal
     __  ___     ___ ____  __
    /  |/  /_ __/ __/ __ \/ /    Mr. Alexander Keremidarski <[email protected]>
   / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
  /_/  /_/\_, /___/\___\_\___/   Sofia, Bulgaria
          <___/  www.mysql.com




-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]