Try OpenEdge Now
skip to main content
Internationalizing Applications
Understanding Character Processing Tables : The convmap.dat file and its tables : Modifying OpenEdge collation tables : Dumping a collation table
 
Dumping a collation table
Dumping a collation table is the first step in modifying the table.
To dump a collation table:
1. In the Data Administration tool, choose Admin > Dump Data and Definitions > Collation. The Dump Collation Tables dialog box appears.
2. In the Output File field, type a dump name (_tran.df is the default), then choose OK.
3. Enter the name of the code page with which the file will be written out.
The _tran.df file contains the collation table for your database. The following figure shows a sample _tran.df file.

Sample _tran.df file

UPDATE DATABASE "?"
COLLATION-TRANSLATION-VERSION 1.0-16
COLLATION-NAME "basic"
INTERNAL-EXTERNAL-TRAN-TABLE
?
EXTERNAL-INTERNAL-TRAN-TABLE
?
CASE-INSENSITIVE-SORT
/*000-015*/ 000 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015
/*016-031*/ 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031
/*032-047*/ 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047
/*048-063*/ 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063
/*064-079*/ 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079
/*080-095*/ 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095
/*096-111*/ 096 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079
/*112-127*/ 080 081 082 083 084 085 086 087 088 089 090 123 124 125 126 127
/*128-143*/ 176 177 178 179 180 185 186 187 188 191 192 193 194 195 196 197
/*144-159*/ 200 201 202 203 204 205 206 213 217 218 219 220 223 242 000 158
/*160-175*/ 255 173 189 156 207 190 221 245 249 184 229 174 199 240 199 238
/*176-191*/ 248 241 253 252 239 230 244 250 247 251 229 175 172 171 243 168
/*192-207*/ 065 065 065 065 065 143 146 067 069 069 069 069 073 073 073 073
/*208-223*/ 068 078 079 079 079 079 079 158 157 085 085 085 085 089 222 000
/*224-239*/ 065 065 065 065 065 143 146 067 069 069 069 069 073 073 073 073
/*240-255*/ 068 078 079 079 079 079 079 246 157 085 085 085 085 089 222 089
CASE-SENSITIVE-SORT
/*000-015*/ 000 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015
.
.
.
/*240-255*/ 208 110 111 111 111 228 111 246 155 117 117 117 117 121 231 121
.PSC
cpstream=ibm850
.0000005361
Note: The IBM850 code page that appears in the trailer of the sample _tran.df file in the figure is not the code page name of the database. It is the code page that was used to write out the data definition (.df) file.