Stops returning rows from query after reach certain number
说明
I run a query and then click the fetch all button. When it gets to a certain number of rows, SQL Navigator stops and will not continue to return rows. No errors return either, it just stops.
原因
One reason for the difference between versions 5.5 and 6.2 is the newly added Unicode support. In 6.2 we always store character data as 2 bytes per character, so it takes twice as much memory.
解决办法
WORKAROUND: Change the National Language Support preference, which can be found by selecting View | Preferences | General - Session. Make sure this preference is set to "No Support". This is not guaranteed to resolve the problem, but does in some cases.
STATUS: Waiting for fix to be released in a future version of SQL Navigator.