Recent content by astenmarquis

My computer crashed and I got the popup that recovery files were found and whether I wanted to recover them. But the date and time stamps were all question marks. Needless to say, it recovered nothing. I've gotten used to relying on the crash recovery so have not been saving all my open windows...

I just removed the NLS_LANG, NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET environment variables and this fixed my problem with the error messages. I can still see the Chinese characters when I query a table containing them and I can paste them in on a select...for update statement. However, I...

I came across Query Reporter on a previous occasion as a potential tool for some of our users to allow them access to the database without having the ability to edit data. During testing, we found that you could put an Update statement in the SQL window and actually alter data. My IT manager...

I tried changing NLS_LANG to SIMPLIFIED CHINESE_CHINA.UTF8. This caused PL/SQL Developer to generate the warning that the database character set (WE8MSWIN1252) and the Client character set (UTF8) are different. Noentheless, I tried my update statement and still got the upside down question marks...

Also, I can do a select .... for update and paste in the Chinese characters and they get saved and properly display when querying the record.

I can query a table and see the Chinese characters. But when I try to do an update statement to that record with different Chinese characters, the result is ??????? which shows up when I re-query the record. update chcrpdta.f0101 set abalph='Imagine Chinese Characters Here' where aban8=1004405...

--- Info --- PL/SQL Developer Version 7.1.5.1398 01.50846 - 30 user license Windows XP Professional 5.1 Build 2600 (Service Pack 2) Physical memory : 2,086,672 kB (924,736 available) Paging file : 4,024,836 kB (2,983,028 available) Virtual memory : 2,097,024 kB (1,995,796...

We have international locations which have recently joined our organization which forced us to convert our Oracle database to Unicode. I have been modifying settings to try to get the ability to insert or update database tables with Chinese characters, but have been unsuccessful. As a side...

Sorry, I found it.

It seems like in v6 the nulls in the SQL window were quite visible. Now on v7, I can't see them and haven't found anything in the preferences that allows to change the color of a null field. Is there such a setting?