Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] UPCASE does not work on special characters
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] UPCASE does not work on special characters
 Login/Join
 
<JJI>
posted
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,
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
<JJI>
posted
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.
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
<JJI>
posted
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,
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] UPCASE does not work on special characters

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.