Recent content by Viliam Durina

  1. V

    Trailing spaces trimmed when comparing tables

    Hi, I used the Compare Table Data function to compare a table with a varchar2(1) not null column. When the column contained single space, the generated inserts contained empty string, and hence the insert failed. It seems that plsqldev removes trailing spaces... Version is 7.1.0.1337. Thanks...
  2. V

    Unicode support in Compare Table Data

    The version is 7.1.0.1337. Viliam
  3. V

    Unicode support in Compare Table Data

    I'd like to enhance the Compare Table Data utility to support NVARCHAR2 columns. Currently, question marks are inserted instead of every character that does not have an equivalent in the DB character set (this is the result of conversion from NVARCHAR2 to VARCHAR2). Thanks, Viliam
  4. V

    Problem with character encoding when editing CLOB

    The problem does not reproduce in 7.0.0 and 7.0.2 version, but does with 7.0.3 version, it seems like a bug. Tested with OCI 10.1 and 10.2.
  5. V

    Problem with character encoding when editing CLOB

    I've sent an e-mail.
  6. V

    Problem with character encoding when editing CLOB

    I have NLS_LANG setting AMERICAN_AMERICA.EE8MSWIN1250. The database charset is EE8ISO8859P2. When I have national characters in varchar2 fields, they work perfectly. But when having them in CLOB, they are incorrect. This happened after I upgraded from instant client 10.1 to Oracle Express...
  7. V

    Variable width font

    Hi, I use variable width font to edit source with PLD. It works quite well, but: I'd wish to set different font for command window (only for dialog tab, not for editor) Large data editor on the text tab could also use fixed width font or have a fixed/variable switch In sql window, when the...
  8. V

    Hangs on any query on table with XMLtype column

    This query reliably fails with PL/SQL Developer 6.0.6.947 and oracle client 9.2: select xmlelement(dummy) from dual; The same query with Oracle Instant Client 10.2 causes following error in SQL Window: OCI-21500: internal error code, arguments: [58], [], [], [], [], [], [], [] OCI-21500...
See more
Back
Top