Oracle Problem [RESOLVED]

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
thomas777neo
Forum Contributor
Posts: 214
Joined: Mon Mar 10, 2003 6:12 am
Location: Johannesburg,South Africa

Oracle Problem [RESOLVED]

Post by thomas777neo »

Hi There

Oracle does a weird thing when trying to record a URL in a field e.g.

If I execute this query:

Code: Select all

INSERT INTO table (id, url_field) VALUES (1, 'container.php?whattodo=test/example.php&right=workgroup');
It asks me to insert the the value for right:

So I type in workgroup.

What it actually records in the database looks like this:

container.php?whattodo=test/example.phpworkgroup=workgroup

So it renames my variable and removes the &

Any ideas to have it insert correctly?

EDIT: Use SET DEFINE OFF
Post Reply