16.1.2 Other Files
Load Other Files automatically creates field definitions as required. If the underlying database column is stored in the database as Unicode, LANSA will automatically create or reuse an appropriate field along the following guidelines:
- If the file definition already exists, and it contains any Char or String fields with the SUNI attribute, any new fields created for Unicode database columns will be created as Char, String, or CLOB fields with the SUNI attribute.
- The only exception to this rule is the IBM i native type Alpha with CCSID 1208 (UTF-8), which is always loaded as Nchar or Nvarchar.
- If it is a new file, or there are no Char or String fields with the SUNI attribute on the file, Load Other File will create Unicode fields as Nchar or Nvarchar.
Refer to 16.3.4 Other Files with SUNI Fields
for details on how you might change existing Other Files from using SUNI fields to 16.1.1 Unicode Field Types.
16.2 Developing New Applications with Unicode
16.3 Modifying Existing Applications to use Unicode
Load Other File in the Visual LANSA Developer's Guide or Load Other File in the Technical Reference Guide.