Invalid Characters '(' and ')' in Insert Statement
alanhayFeb 27 2009 — edited Apr 21 2009I'm a sometime Oracle user having trouble inserting text containing ( and ) characters.
Example:
INSERT INTO _funds
(fund_id, fund_name, fund_desc)
VALUES (11, 'British Opportunities', 'The fund''s aim is to maximise total return (the combination of income and growth of capital) from a portfolio investing primarily in UK equities.The rate of growth of funds cannot be guaranteed. This fund invests in the fund manager''s own collective investment fund of the same name.');
Results in : [Err] ORA-00911: invalid character
I've tried escaping with \ and wrapping in {} but just cannot get this to work. Should there be an issue with these characters. Could it be my client (Navicat)?
Thanks.
Alan
(Server 9.2.0.1.0 on Windows)
(Server 9.2.0.1.0)
Edited by: user7578531 on Feb 27, 2009 1:16 PM
Edited by: user7578531 on Feb 27, 2009 1:16 PM
Edited by: user7578531 on Feb 27, 2009 1:17 PM