One of our developers wants to put the following into his database...
St James's
...including the '.
Obviously insert into tab values ('St James's') doesn't work and not being an expert in these kind of things I'm a bit stumped. Any clues?
Printable View
One of our developers wants to put the following into his database...
St James's
...including the '.
Obviously insert into tab values ('St James's') doesn't work and not being an expert in these kind of things I'm a bit stumped. Any clues?
Try double single quotes:
e.g.
insert intovalues ('St James''s')
___________________________
John
Forget this, the development department have fixed it.
If you insert 'St Jame''s' it is ok. Oracle sees this as one character ' instead of the character to open and close a textinput.
Rik
How did the developement department fix it?