Toad World® Forums

Invalid character Error

I have run a simple query to extract a table for data auditing. My code is literally:

select * from table;

It has ~13000 rows, which is not large. The query runs and then I get the following error:

[Warning] An invalid character was found in text content.
(1: 68826743): Error at line 1
An invalid character was found in text content.

Any suggestions on how I can get around this or look up the value causing a problem?

Hi,
it's probably an escape code in a column. Avoid "select *"
start to select column one by one to locate the bad one, then try to cast it in another way...

1 Like

That is entirely too logical and what I should have done in the first place.