List! I would like to give credit to a man from Gothenburg, Sweden. He called by phone and told me how to resolve my sorting problem. Helpfiles coming with Rbase regarding sorting with international characters seem to partly emanate from DOS times. The ASCII table is from DOS time and the numbers for letters are not correct for Windows XP and later. Try to make a table with two columns (letter and (ichar(letter))). You will now see the characternumbers. In the COLLATE section of rbengine.cfg you have number pairs. The first number is the character number and the second number shows in what order that letter is sorted. So in my case åä is sorted together with a and ö with o. Now I want those three letter to end up after z that have the number 122 in the US alphabet. So I give them numbers 124, 126 and 129. Then the helpfiles are correct. One must have a rbengine.cfg file together with the database. A corrected *.cfg file ie. Then as the helpfile and list has told me do a PACK "database" ALL WITH USER CASE. Then the corrections are saved within the database. The ASCII table in the helpfiles is old I would say. Thank you all. /Christian
On 29 sep 2012 19:50 "Albert Berry" <[email protected]> wrote: > I think you need to work out where the characters fit. I found a help > entry that might help your problem solving. Look up "COLLATE" in the > help search, then click on international characters. There are several > tables in there that I have never, ever, even looked at. It might sort > out your thinking. > > 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. > > >
