Storing text fields with imbedded punctuation

[parnellsquare]

I am a software tester - the developers I am working with are telling me there is no way to allow users to enter text that includes punctuation marks like apostrophes, quate marks, semi-colons, ampersands because Oracle will not allow this to happen.

I find it hard to believe that a database as powerful as Oracle does not have a way to do this? Any helpful information I can share with the developers would be greatly appreocated.

The text fields in question are text entry fields of either 100 or 500 or 1000 characters being used to store planning objectives for the users.

[Saii]

I am a software tester - the developers I am working with are telling me there is no way to allow users to enter text that includes punctuation marks like apostrophes, quate marks, semi-colons, ampersands because Oracle will not allow this to happen.

I find it hard to believe that a database as powerful as Oracle does not have a way to do this? Any helpful information I can share with the developers would be greatly appreocated.

The text fields in question are text entry fields of either 100 or 500 or 1000 characters being used to store planning objectives for the users.

Yes, we can store apostrophes, quotes, semi-colons, ampersands in Oracle but they have to handled("escape d") as these are wild cards used in Pl/SQL, like in any other language. While processing this type of text, we have to find these characters and use escape characters.
This involves some extra effort.

[debasisdas]

Yes they can be stored in database but need to be handled separately as suggested by Saii.