insert the + character in a char or varchar column

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.

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.

Thank you,
Philippe Guiol

____________________________________________________________ _____
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

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

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: fred.van.engen@xbn.nl 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/bugs?unsub=gcdmb-bugs@m.gmane.org

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 bugs@lists.mysql.com

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
/ /|_/ / // /\ \/ /_/ / /__ 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/bugs?unsub=gcdmb-bugs@m.gmane.org