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,
September 10, 2010, 05:11 AM
GamP
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.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
September 10, 2010, 04:00 PM
<JJI>
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.
September 10, 2010, 05:26 PM
FrankDutch
you may concider the use of "Les Pays Bas" in stad of "Neerlandais".....
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
September 13, 2010, 07:18 AM
<JJI>
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.