Toad World® Forums

Data Grid


#1

I downloaded data from a file to an Oracle table. The file had low values. In Schema Browser, I used a filter to do a search and my rows are selected, but once the low values are detected, the rest of the data becomes invisible. How do I get around this issue


#2

Many windows programs interpret ASCII-0 values as “end of string”. Toad is one of them, and unfortunately, this isn’t configurable.

You can repeat the problem with this query:

with data as

(select ‘data’ || CHR(0) || ‘more data’ as text

from dual)

select *

from data;

You can work around it by replacing the ASCII 0 with something else, like this:

with data as

(select ‘data’ || CHR(0) || ‘more data’ as text

from dual)

select replace(text, CHR(0), ‘<ASCII 0>’) text

from data;