Oracle Support

Add new encoding types to alpha fields, RAW, NATIONAL, and UNICODE to our Oracle interface

Overview

The Encoding Type attribute of an alpha field determines the format of the data column within an Oracle database.

• RAW
  • "clob" if greater than 4000 bytes.
  • "char(# bytes)" if a key segment or less than 6 bytes.
  • "varchar(# bytes)"
• UNICODE
  • "clob" if greater than 4000 bytes. (should this be characters?)
  • "char(# char)" if a key segment or less than 6 bytes. (should this be less than 6 characters?)
  • "varchar(# char)"
• NATIONAL
  • Not defined and the code will follow UNICODE. (this seems wrong)

(I saw nothing in the source code to deal with Alpha Dates with special Encoding Types)

When an Oracle record is read from disk, the file manager will convert the record buffer from its external disk format to its internal memory format.

When an Oracle record is written to disk, the file manager will convert the record buffer from its internal memory format to its external disk format.

Test Plan:

FMS Types: (untested)

Test Requirements:

Do all encoding types seem to create the correct oracle columns with the right byte or character sizes?

Can you write and read raw, unicode, and national data from within appx?

Can you write and read raw, unicode, and national data from outside of appx?

Can you write raw, unicode, and national data from appx and read it outside of appx with the correct characters?

Test Results and Notes:

untested

-- PeteBrower - 2011-03-09