Progress
Database Administration
Guide and Reference
PROUTIL CONVCHAR Qualifier
Converts a database’s character set or identifies a database’s character set (for undefined databases). When converting a database’s character set, PROUTIL CONVCHAR converts all of the textual data in the database.
SYNTAX
Operating System Syntax UNIXWindows proutil db-name -C convchar [analyze
|charscan
|convert
][codepage] [character-list]
db-name
Specifies the database you are converting.
analyze
Scans the database and displays the fields that would be converted using the
convert
function.
charscan
Searches every character field for the occurrence of any character from the provided character list and reports the table name, field name, record ID of a match, and the total number of occurrences. In addition, PROUTIL CONVCHAR CHARSCAN performs the same analysis that PROUTIL CONVCHAR ANALYSIS performs.
If invalid data are entered with the
charscan
option, PROUTIL CONVCHAR generates an error message and continues with the scan.
convert
Converts a database’s character data to the target code page and labels the database.
codepage
Specifies the value of any single-byte, double-byte, or Unicode codepage. Possible values are undefined or any (target) code page name for a conversion table in your conversion map file (by default,
DLC/convmap.cp
). If you specify a code page name, the PROUTIL CONVCHAR utility must find the appropriate conversion table in the conversion map file. If you specify undefined, no conversions take place and the database’s code page name is changed to undefined.If you specify a code page name against a database with a code page name of undefined, no conversions take place and the database’s code page name is changed to the value you specify.
NOTE: When you change the code page of a database from “undefined” usingproutil
dbname
-C convchar convert
codepagePROUTIL CONVCHAR generates warning messages. After you receive these messages, you might need to load the collation table for the code page. The collation table data definition files have a .df extension and are located in $DLC/prolang/<language>.
When you specify a codepage value with
analyze
, it scans the database and identifies the database’s current code page encoding and the fields that require translation if you were to use the convert function with that code page specification.When you use the codepage parameter with
convert
, it specifies the code page to which you want to convert the database and specifies the code page name for the database.character-list
Specifies a quoted string of comma-separated numbers in either hex or decimal. These numbers represent character values in the codepage. Specify ranges with a minus sign (
NOTE: Quotes are not needed if there are no blanks within the list (“128 - 144”)
.
128-144,122).
Hex values must begin with
0x.
For example, the syntax to run PROUTIL CONVCHAR with the decimal list“128, 129, 130”
provided in hex is:
Note also that hex and decimal values may be mixed. For example:
If a range contains valid and invalid characters, PROUTIL CONVCHAR ignores the invalid character. For example, this syntax
searches and returns the following:
If
charscan
is selected but no character list is specified, theanalyze
function performs.For more information about character set processing, see the Progress Internationalization Guide .
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |