PSCHARSETS

(SQL Table)
Index Back

List of valid character sets

PSCHARSETS stores a list of valid character set (encoding) names which Tools supports for FileObject class (PeopleCode) and in our application products.

  • Related Language Record: PSCHARSETSLANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHARSET Character(40) VARCHAR2(40) NOT NULL Character Set
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 MAX_BYTES_CHAR Number(2,0) SMALLINT NOT NULL Max # of Bytes per Character
    5 UNICODE_CHARSET Character(1) VARCHAR2(1) NOT NULL Unicode or a Transformation?

    Y/N Table Edit

    Default Value: N

    6 CHARSET_TYPE Character(1) VARCHAR2(1) NOT NULL Character Set Type
    1=Single Byte
    2=Multi-Byte Non-Shifting
    3=Multi-Byte Shifting
    4=Multi-Byte Fixed
    9=Other / Unknown

    Default Value: 1

    7 WINDOWS_VALID Character(1) VARCHAR2(1) NOT NULL Windows Valid Character Set