The content of sqle850a.h is shown in Figure 53.įigure 53. This purpose is supplied with DB2 in the sqle850a.h includeįile. ![]() To achieve the desired collation, you need to create your database with a ![]() The code page 850 binary collation (which is not the desired sequence) If you create the database with ASCII code page 850, binary collation would The code page 500 binary collation sequence (the desired sequence) See Figure 54 for the definition of code page 500, and Figure 55 for the definition of code page 850.Ĭonsider the relative collation of four characters in a EBCDIC code pageĥ00 database, when they are collated in binary: Strings to be collated as if the data actually resides in an EBCDIC database ![]() You can use this feature to simulate EBCDIC binaryĪs an example of how to simulate EBCDIC collation, suppose you want toĬreate an ASCII database with code page 850, but you also want the character With DB2, you can collate character strings according to a user-definedĬollating sequence.
0 Comments
Leave a Reply. |