PSCOLLATIONS

index back

Collation Information


PeopleSoft Field NameField TypeColumn TypeDescription
COLLATION_TYPECharacter(3)VARCHAR2(3) NOT NULLCollation Type Information
000=Binary Sorting
B00=Latin1 (Default)
B01=Canadian French (General)
B02=Danish (General)
B03=Dutch (General)
B04=Spanish (General)
B05=French (General)
B06=German (General)
B07=Italian (General)
B08=Japanese (General)
B09=Portuguese (General)
B10=Swedish (General)
B11=Simplified Chinese (General)
B12=Traditional Chinese (General)
B13=Danish (Linguistic)
B14=Dutch (Linguistic)
B15=Spanish (Linguistic)
B16=French (Linguistic)
B17=German (Linguistic)
B18=Italian (Linguistic)
B19=Portuguese (Linguistic)
B20=Swedish (Linguistic)
B21=Japanese (Linguistic)
B22=English
COLLATION_NAMECharacter(40)VARCHAR2(40) NOT NULLPhysical name of collations
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19