Christian, James are on the right track here, on top of his recomendations any changes to case folding does only comes into effect if you a RELOD YOURDB with user case
Hope it helps Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För James Bentley Skickat: den 30 september 2012 04:04 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: [RBASE-L] - Re: Sorting åäö The following is from RBase Help: < style type="text/css"> html, body { overflow: auto; }< /style> Navigation: Reference Index > Reference Topics > International Characters <http://us.mg5.mail.yahoo.com/neo/information_management.htm> Previous page <http://us.mg5.mail.yahoo.com/neo/introducingrbaseextreme.htm> Return to chapter overview <http://us.mg5.mail.yahoo.com/neo/multi-userconsiderations.htm> Next page The R:BASE configuration <http://us.mg5.mail.yahoo.com/neo/configuration_file_glossary.htm> file contains tables that define how R:BASE processes and prints characters. If you want to change how R:BASE evaluates characters, you can modify the information in these tables, which are described below. R:BASE saves table configurations with the database. If you make modifications to these tables in the configuration file, use the PACK <http://us.mg5.mail.yahoo.com/neo/pack.htm> command with the WITH USER CASE option to compress the database and apply the new configuration. The Case Folding Table The Case Folding table establishes the correspondences between uppercase and lowercase characters, such as "A" and "a." R:BASE uses this table when testing characters for equality when the CASE <http://us.mg5.mail.yahoo.com/neo/set_case_2.htm> setting is off. Each line in this table starts with "CASEP" and is followed by two ASCII character <http://us.mg5.mail.yahoo.com/neo/asciicharacterchart.htm> codes corresponding to the uppercase and lowercase characters. For example, the following line shows that "a" (ASCII code 97) corresponds to "A" (ASCII code 65): CASEP 97 65 The Collating Table The Collating table equates two characters in sorting and inequality testing (>, >=, <, and <=). Each line in this table begins with "COLLATE" and is followed by two ASCII character codes, whose corresponding characters are considered equal in a sorting sequence. For example, the following lines indicate that "a" (ASCII code 97), "ä" (ASCII code 132), and "A" (ASCII code 65) are all equal in a sorting order: COLLATE 97 65 COLLATE 132 65 The Printer Table The Printer table tells the printer how to print certain characters. Some printers cannot print certain international characters, such as characters with accents or umlauts, so the printer must combine two or more characters to create the international character. Each line in this table begins with "FOLD" and is followed by a character and its ASCII code, then one or more ASCII codes whose corresponding characters must be combined to create the first character. For example, the following line tells the printer how to print "à" (ASCII code 133); print "a" (ASCII code 97), backspace (BS), then print an accent "`" (ASCII code 96): FOLD à 133 97 BS 96 If your printer can print a character without combining other characters, do not delete the line. Instead, edit the line. After "FOLD," enter the character, the character's ASCII code two times, then "00 00." For example, if your printer can print "à," edit the line as follows: FOLD à 133 133 00 00 The Expansion Character Table The Expansion Character table equates one character to two other characters. For example, you can equate "ß" to "SS." This table is used in tables, columns, variables, WHERE clauses, ORDER BY clauses, IF and WHILE commands, and indexed and non-indexed columns. Each line in this table begins with "EXPAND" followed by three ASCII character codes. You can have up to seven lines in this table. For example, the following line equates "ö" (ASCII code 148) to "oe" (ASCII codes 111 and 101): EXPAND 148 111 101 The Character Folding Table The Character Folding table equates uppercase characters to lowercase characters. This table is used in string-manipulation functions. Each line in this table begins with "LCFOLD" and is followed by two ASCII character codes. For example, the following line equates "A" (ASCII code 65) to "a" (ASCII code 97): LCFOLD 65 97 The Case-Sensitive Collating Table The Case-Sensitive Collating table lists characters and their position in the sequence order of all characters. This table is used when the CASE setting is on and when building indexes for columns with the TEXT data type. Each line in this table begins with "COLLATEC" and is followed by an ASCII character code and its sequence position. For example, the following line indicates that "B" (ASCII code 66) is in the 76th position in the sequence order: COLLATEC 66 76 If a character is not in this list, its sequence position number is the same as its ASCII character code. Jim Bentley, American Celiac Society 1-504-737-3293 _____ From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, September 29, 2012 10:47 AM Subject: [RBASE-L] - Re: Sorting åäö You have just exceeded my knowledge level Christian. Perhaps one of the true genius people can help. Albert On 27/09/2012 1:40 PM, Christian Hjortmar wrote: > Thankyou, Albert! > Rbase 9.1 does make a new configurationfile if none is there. > I was not looking in the right catalogs. > Then my sorting problem is left. > In the configuration file there are sections called collate and collatec and I guess they are the ones to operate on. But I am not sure how. In the collate section I inserted "COLLATE 132 142" and in the collatec section I inserted "COLLATEC 132 125". > Saved the configuration file with the database. Started rbase then made a "pack db all with user case". Closed the database and opened it again and opened the experiment alphabet table and sorted it. Still I have the alphabet in the order "aäåbcd........". > What more am I missing in changing the configuration file? > > Christian
