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
