Problems with Special characters in AXIANT Thin Client

Frederiksen Tim tifre@wmdata.com
Fri, 1 Aug 2003 13:45:46 +0200


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C35822.71F6D500
Content-Type: text/plain;
	charset="iso-8859-1"

Hello,  

I have a problem with special danish characters, when retrieving data from a
CISAM table stored on AIX/UNIX server. 
The tables a accessed throw AXIANT server on the UNIX,  to a thin Windows
AXIANT client.
 
I think the problems is, the CISAM files are stored in a UNIX 8-bit ACSII
character set, 
and are not converted into a windows characterset when send to the AXIANT
client.
 
I had the same problem with our ORACLE base but setting the variable
NLS_LANG into a windows character set 
in the PH8INIT file was the solution. (our ORACLE base is also in a 8-bit
ASCII characterset )
 
Since we are converting a POWERHOUSE application, we can't just convert the
CISAM datafiles into
and windows characterset, because we still want the POWERHOUSE application
running.
 
We need some kind of setup that converts data on run time. 
 
Regards 
Tim Frederiksen
 
 

------_=_NextPart_001_01C35822.71F6D500
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY style="COLOR: #000000; FONT-FAMILY: Arial">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma><SPAN 
class=630044511-01082003></SPAN><FONT size=2>H<SPAN 
class=630044511-01082003><FONT face=Arial>ello, 
&nbsp;</FONT></SPAN><BR></FONT></FONT></DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2>I have a problem with special 
danish characters, when </FONT></SPAN><SPAN class=343191211-01082003><FONT 
size=2>retrieving data from a CISAM table&nbsp;stored on AIX/UNIX server. 
</FONT></SPAN></DIV>
<DIV><SPAN class=343191211-01082003></SPAN><SPAN 
class=343191211-01082003></SPAN><SPAN class=343191211-01082003><FONT 
size=2>The&nbsp;tables a accessed </FONT></SPAN><SPAN 
class=343191211-01082003><FONT size=2>throw AXIANT server on the&nbsp;UNIX, 
&nbsp;to a thin Windows&nbsp;AXIANT client.</FONT></SPAN></DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2>I think the problems 
is,&nbsp;the CISAM files are stored </FONT></SPAN><SPAN 
class=343191211-01082003><FONT size=2>in a UNIX 8-bit ACSII character set, 
</FONT></SPAN></DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2>and are not converted into a 
windows characterset when send&nbsp;to&nbsp;</FONT></SPAN><SPAN 
class=343191211-01082003><FONT size=2>the AXIANT client.</FONT></SPAN></DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2>I had the same problem 
with&nbsp;our ORACLE </FONT></SPAN><SPAN class=343191211-01082003><FONT 
size=2>base but setting the variable NLS_LANG into a windows character set 
</FONT></SPAN></DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2>in the PH8INIT file was the 
solution. (our ORACLE base is also in a&nbsp;8-bit ASCII&nbsp;characterset 
)</FONT></SPAN></DIV>
<DIV><SPAN class=343191211-01082003></SPAN><SPAN 
class=343191211-01082003></SPAN><SPAN class=343191211-01082003><FONT 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2>Since we are converting a 
POWERHOUSE application, we can't just convert the CISAM datafiles 
into</FONT></SPAN></DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2>and windows characterset, 
because we still want the&nbsp;POWERHOUSE 
application&nbsp;running.</FONT></SPAN></DIV>
<DIV><FONT size=2><SPAN class=343191211-01082003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT size=2><SPAN class=343191211-01082003>We need some kind of setup that 
converts data on run time.&nbsp;</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=343191211-01082003></SPAN></FONT>&nbsp;</DIV>
<DIV><SPAN class=343191211-01082003><SPAN class=630044511-01082003><FONT 
size=2>Regards </FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=343191211-01082003><SPAN class=630044511-01082003><FONT 
size=2>Tim Frederiksen</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=343191211-01082003><FONT size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=343191211-01082003><FONT 
size=2></FONT></SPAN>&nbsp;</DIV></BODY></HTML>

------_=_NextPart_001_01C35822.71F6D500--