Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer -

Turlock22Jan 23 2013 — edited Jan 23 2013
We're having a problem with a windows application where intermittently when loading data (adhoc only for rollouts, not a regular thing :) ) the new line characters show as boxes in the front end application. We've narrowed the problem down to how the new lines are stored in the database.

SQL Navigator stores them correctly as Chr(13) || Chr(10) where SQL Developer is storing them as just Chr(10). I've tried setting the "Line Terminal" correctly to CR&LF (Windows) but that hasn't helped.

Has anyone ever come across this before? The text being copied and pasted into SQL developer definitely has CR&LF but I reckon they're just being replaced by Developer. Woulda thought the "Line Terminal" woulda sorted it but apparently not.

Checked with Oracle and they're happy that there aren't any conversions on the DB so it's 100% client related...

Loading it from Windows 7, SQL Developer version 3.2.20.09 and the db is version 10.2.02

Thanks!

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 20 2013
Added on Jan 23 2013
#sql-developer
2 comments
135 views