Menu

#6 + sign unable to insert

closed
None
5
2001-10-18
2001-10-15
No

Hello,

IS this a MYSQL issue or a phpMyAdmin ?

We cannot run an insert of a plus sign into a varchar
field.

CREATE TABLE test (
ID int(11) NOT NULL auto_increment,
TEST varchar(50) NOT NULL default '',
PRIMARY KEY (ID),
KEY ID(ID)
) TYPE=MyISAM;

#
# Dumping data for table `test`
#

INSERT INTO test VALUES (1,'test test');

but if I edit and add a + sign in the interface it is
a no go but I can via straight SQL

update test set test = 'test+test' where ID =1

Discussion

  • Loïc Chapeaux

    Loïc Chapeaux - 2001-10-16

    Logged In: YES
    user_id=144058

    Hi!

    This is a known bug of the 2.2.0 version. We've already
    fixed it then you may either use the 2.2.1-rc1 now or wait
    till the plain 2.2.1 is released.

    Loc

     
  • Loïc Chapeaux

    Loïc Chapeaux - 2001-10-16
    • assigned_to: nobody --> loic1
     
  • Loïc Chapeaux

    Loïc Chapeaux - 2001-10-18
    • status: open --> closed