[RBASE-L] - Re: Contains with National charcters

[Gunnar Ekblad]

Thanks Alistair I will give it a go This a small routine I use to convert from DOS to win I guess that is the number I need to figure out where to put in rbase cfg “ *(Convert textcolums with dos text to wintext    %1 table    %2 doscol    %3 wincol   Gunnar Ekblad ) set case on                                   *(† å) set v v1d to (char(134));set v v1w to (char(229)) *( Å) set v v2d to (char(143));set v v2w to (char(197)) *(„ ä) set v v3d to (char(132));set v v3w to (char(228)) *(Ž Ä) set v v4d to (char(142));set v v4w to (char(196)) *(” ö) set v v5d to (char(148));set v v5w to (char(246)) *(™ Ö) set v v6d to (char(153));set v v6w to (char(214)) drop cursor c#1 set pointer c#1 e1 for &%1 while e1 = 0 then set v vdos to &%2 where current of c#1 set v vwin to (srpl(.vdos,.v1d,.v1w,0));set v vwin to (srpl(.vwin,.v2d,.v2w,0)) set v vwin to (srpl(.vwin,.v3d,.v3w,0));set v vwin to (srpl(.vwin,.v4d,.v4w,0)) set v vwin to (srpl(.vwin,.v5d,.v5w,0));set v vwin to (srpl(.vwin,.v6d,.v6w,0)) write .vdos ' ' .vwin update &%1 set &%3 to .vwin where current of c#1 next c#1 e1 endw set case off   If it works in rbase.cfg I ma grateful Gunnar   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: den 1 april 2003 19:37 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Contains with National charcters   Hi Gunnar,   I haven't got a Swedish keyboard layout available at the moment but I suspect that your problem is to do with the differentiation between upper and lower case (capitals & non-capitals) in the rbase.cfg case/fold/collate sections.   If you work out the 4 digit code for each upper and lower case pair you ought to be able to insert them in the appropriate section.   As always, make sure to keep a backup copy of the cfg file if you already have any personalisation in it.   I have to admit that I always insisted that nobody in the European offices used their accented and special characters unless they wanted to pay for me to visit them to correct their problems. It didn't make me popular but it did save the company some money!!   Regards, Alastair.       ----- Original Message ----- From: Gunnar Ekblad To: RBASE-L Mailing List Sent: Tuesday, April 01, 2003 12:07 PM Subject: [RBASE-L] - Contains with National charcters   At long last I have started my first Windows application. I have started with 6.5++ 1.864 If I rename dear employee# 131 to Mary Örnqvist in CONCOMP database If I then do R> sel all from employee where emplname contains ‘Ö’  *( Capital national character Ö) I will get One row as expected If I then do R> sel all from employee where emplname contains ‘ö’  *( Gemen (is that English for non capital?) national character ö) I will get no rows satisie….   If I repeat with T and t I will have the same result of 3 rows, that is :T is not case sensitive Ö seams to be!   It is in a dynamic where clause in a popup I need the search to valid for national charters without being casesensitive.   For version 1.864 I am not worried, but it seams to me that it is the same in 7.0 (After a minor test in DEMO-READ only version of 7.0 it seems that the problem stays in 7.0   Can I hope that R:DCC put this on the list of small things to fix?     Gunnar Ekblad