Hi,

I have this strange behaviour with the use of the subroutine UPCASE. On the DEVELOPMENT machine the following code works perfect:

COMPUTE CMP_LANG/A255 = UPCASE(255,DES_LANGUAGE,'A255');  

EXAMPLES:
input : néelandais result : NÉERLANDAIS
input : François result : FRANÇOIS


But on the production machine the same code produces the following:

input : néelandais result : NéERLANDAIS
input : François result : FRANçOIS

I don't understand this behaviour because on both machine everything (so it seems) is the same.

- NLS settings on WF server and WF client are the same (codepage 137 American/English (Latin 1))
- WF version: 7.1.7
- OS: WIN 2003 SP2
- SQL server: reporting against the same SQL data on the same server
- Regional setting on both servers are identical
- The code for the the dev. machine and the production machine are the same and ran from the same Dev studio/MRE or via a browser
- browser version is the same (IE 8)

Even more strange is that when I use this peace of code in a DEFINE or COMPUTE:

 IF UPCASE(255,DES_LANGUAGE,'A255') EQ 'NÉERLANDAIS' THEN 'N' ELSE.... 

I get 'N' as a correct result when DES_LANGUAGE is 'néerlandais' despite the fact that displaying the UPCASE of DES-LANGUAGE results in 'NéERLANDAIS' and not 'NÉERLANDAIS'


All ideas to solve this problem are welcome.

Kind regards,

This message has been edited. Last edited by: Kerry,

Could it be that there are small differences in the OS? It might be that this is not webfocus related, but os-related.
If I were you, I would open a case with IB tech support. They should be able to give you a possible solution along with a reason of why this happens.

Hi GamP,

quote:

Could it be that there are small differences in the OS?

This is what came to my mind, when I investigated this problem and couldn't find any differences in the 3 WF environments. That is the reason why I tried my luck on this forum first. I was hoping somebody already came across this strange behaviour and could point me in the right direction. If not I'll need to open a case with IB Tech. Supp.

Thanks for you reaction.

you may concider the use of "Les Pays Bas" in stad of "Neerlandais".....

Hi Frank,

Thanks for your reply.
Since the data is about the language and not about a country we can't use your suggestion because this is not correct French and above al this the value for DES_LANGUAGE in the DB is supplied by an other application.

Kind regards,