SQL Developer -

Turlock22 Jan 23, 2013 2:48 PM

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!

1. Re: SQL Developer -

thatJeffSmith-Oracle Jan 23, 2013 4:17 PM (in response to Turlock22)

What do you have set for the Line Terminator preference in Tools > Preferences > Environment?
Like Show 0 Likes(0)

Actions
2. Re: SQL Developer -

Turlock22 Jan 23, 2013 4:46 PM (in response to thatJeffSmith-Oracle)

Originally it was "Platform Detect" but I've changed it to CR&LF (Windows) which made no difference then tried the other options, for me it doesn't make any difference to my data at all. Always just ends up as Chr(10) on its own
Like Show 0 Likes(0)

Actions

Go to original post