Consultor Eletrônico



Kbase P45000: The bulkload Utility incorrectly loads CHR(10) into the database.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   03/04/2009
Status: Unverified

SYMPTOM(s):

The bulkload Utility incorrectly loads CHR(10) into the database.

FACT(s) (Environment):

Importing data into a database via bulkload.
Control codes are embedded in the data being loaded.
Bulkload incorrectly loads CHR(10) into the database.
The position of CHR(10) in the record changes after loading the data through bulkload.
Bulkload converts a single line feed character <LF>, which is ASCII Character 10 or a single carriage return character <CR>, which is ASCII Character 13 to <CR>/<LF>. So, CHR(10) or CHR(13) becomes CHR(13) + CHR(10).
This behavior only occurs on Windows. In UNIX, the data remains unmodified.
Windows
Progress 9.1x

CAUSE:

Bug# OE00068861

FIX:

Upgrade to Progress 9.1D08 or later.