-3

The character set of the db is

"WE8MSWIN1252"

and I am inserting the rows through a bat file where I set "NLS_LANG" to

".WE8MSWIN1252"

. At the end of the insertions, some of the rows in SQL Developer display a certain character while some not.

Ameya Deshpande
  • 3,580
  • 4
  • 30
  • 46
Sammy
  • 885
  • 3
  • 13
  • 32

1 Answers1

0

some of the rows in SQL Developer display a certain character while some not.

It is a display issue with your SQL Developer client. Use proper value for the NLS settings in your SQL Developer.

Go to,

Tools --> Preferences --> NLS

enter image description here

Lalit Kumar B
  • 47,486
  • 13
  • 97
  • 124