Re: chr(0) inserted when storing large memo to Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

tom.green@xxxxxxxxxxxxxxxxxxxxxx schrieb:


But when I update my Oracle view to the back end, often a chr(0) gets
inserted randomly, typically around the 2000th character, but I think
that might vary.

I have seen Chr(0) problems back in vfp6 days when using transactions - not connected specifically to oracle. If you are running transactions it might help to isolate the problem if you test a few times without them.

HTH

thomas
.

Relevant Pages

  • Oracle Character Conversion Bugs (#NISR2122004G)
    ... Oracle 10g/AS on all operating systems ... Due to character conversion problems in Oracle 10g with Oracle's Application ... database server as SYS. ...
    (NT-Bugtraq)
  • Re: Storing Queries in Tables
    ... Either you should follow the method Oracle is using to store SQL ... removed all the indents from the query and then they have worked. ... of report, date, other qualifier etc. ... brings me back to character sets. ...
    (comp.databases.oracle.misc)
  • Oracle Character Conversion Bugs (#NISR2122004G)
    ... Oracle 10g/AS on all operating systems ... Due to character conversion problems in Oracle 10g with Oracle's Application ... database server as SYS. ...
    (Bugtraq)
  • [VulnWatch] Oracle Character Conversion Bugs (#NISR2122004G)
    ... Oracle 10g/AS on all operating systems ... Due to character conversion problems in Oracle 10g with Oracle's Application ... database server as SYS. ...
    (VulnWatch)
  • Re: Oracle error with swedish characters
    ... Maybe you can set in the Oracle client on your Windows machine which codepage ... DBI have to use connecting to your Oracle on redhat. ... > oracle the character mentioned is ascii 229. ...
    (perl.dbi.users)