One of our customer reports: Ora-01480 - Trailing null missing from STR bind value. (Ora10 database, delphi7, doa 4.0.6.2)
It happens on a update from a normal oracledataset. The size of the field in de database en tstringfield is 2000. The length of the string being inserterd is approximatly 1100 characters. What could be the problem?
Oracle monitor query generated: update AROOSTERPLOEG set ARP_DIENSTEN = :v1 where rowid = :doa__rowid returning rowid into :doa__rowid
It seems the problem occurs at the sizes above 1000 characters. Th eprogram tries to store a string of 1001 characters.
During the import of their dump it say's: import is uitgevoerd in WE8MSWIN1252 tekenset en AL16UTF16 NCHAR-tekenset. importserver gebruikt WE8ISO8859P15 tekenset (mogelijke tekensetconversie).