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