Hi Are there any other characters with the same problem like #? Thanks
-----Original Message----- From: Robby Tanner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:16 AM To: Stefan Hinz Cc: [EMAIL PROTECTED] Subject: RE: Inserting '#' char as part of a field I solved the issue (eventually) by using a different control. It seems the batch component interprets #'s differently than regular table and query components. I'll use query components in the future. Thanks anywaym, Rob > -----Original Message----- > From: Stefan Hinz [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 17, 2003 4:10 PM > To: Robby Tanner > Cc: [EMAIL PROTECTED] > Subject: Re: Inserting '#' char as part of a field > > > Robby, > > > How can I get MySQL (via ZeosDBO in Delphi 5) to accept the # > > sign? Add extra quotes or a backslash before the character? > Use double > > quotes? Some other method? > > I know about nothing of Delphi and Zeos, but I'd try a backslash > before the # character. Here's what I get with the mysql client: > > mysql> INSERT INTO mytest (bla) VALUES ('#'),('\#'); > Query OK, 2 rows affected (0.03 sec) > Records: 2 Duplicates: 0 Warnings: 0 > > mysql> SELECT bla FROM mytest; > +------+ > | bla | > +------+ > | # | > | # | > +------+ > 2 rows in set (0.00 sec) > > Obviously, the backslash changes nothing, so I guess it won't hurt > trying. > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > > [filter fodder: sql, mysql, query] > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
