Our PC's are locked down so we cannot change settings such as the Control Panel->Regions->Administrative->Language for Non-Unicode programs or the Registry settings or environment variables or even the installed Oracle client settings. We work in a global system where we are routinely dealing with multiple different languages. The other tools show either UTF16 (Toad) or UTF8 (Sql Developer). Querying v$session_connect_info or using PSD Support Info tab I can tell PSD is using AMERICAN_AMERICA.WE8MSWIN1252. The database in question is using AMERICAN_AMERICA.UTF8 lang/terr/charset. This is an NLS_LANG related issue in terms of the way the tools are working. Just encountered issue where a query with Chinese (or Japanese) characters issued from PSD does not return results but the same query executed from Toad (or Oracle Sql Developer) on same pc/database/oracle client works fine and returns expected row. Company recently switched from Toad to Pl/Sql Developer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |