A list of invalid characters
Hi,
I have to insert over 1,500 rows of data with a free form text column callled description (stored in Excel at d mo) that will have to put into varchar2 column in my table.
The problem is there will be a lot of invalid charcters in in the description fields which will stop the rows from being inserted into the table. I can removed the obvious invalid characters like ', &, etc. but i don't know some of the not so obvious characters.
I want to insert the 1,500 rows in batches but my insert statements are getting all messed up because of the invalid characters. I can just remove the invalid charters using Ctrl+H in excel and then batch insert the rows.
Does anybody have a link to a list of all the invalid characters that can't go into an insert statement easily?
Thanks in advance