I want to implement AR8MSWIN1256 characterset to enable me to store English and Arabic data in my database. Should I use VARCHAR2 or NVARCHAR2 datatype to store arabic data? Please exaplain.
Printable View
I want to implement AR8MSWIN1256 characterset to enable me to store English and Arabic data in my database. Should I use VARCHAR2 or NVARCHAR2 datatype to store arabic data? Please exaplain.
Varchar2 will do the job
Some 8-bit data are appearing as '?' mark when viewed thro' Oracle Forms against oracle 8.1.5. the NLS_CHARECTER set is set correct as:
on the server side it's :AR8ISO8859P6
on the clients: AMERICAN_AMERICA.AR8MSWIN1256.
However still it appears as '?'. But when this is working fine against oracle 7.3.4.Any suggestion ?
Thanks. Pands
Check on the server if NT/2000 in Windows registry => software => Oracle and change all character sets ( NLS_LANG ) to either AR8MSWIN1256 or AR8ISO8859P6 .
You will need to adjust it in 3 locations inside Oracle section inside the registry ( on the server ).
Restart server and everything is ok
Quote:
Originally posted by hnagia
Varchar2 will do the job
Nagia ,
Please let me know Where are the 3 places should I have to make 'AR8MSWIN1256' changes in the windows registry? But how is it working fine against oracle 7.3.4. with only one entry ?
Thanks
Pands
I am unable to fix English/Arabic issue. Your help will be appreciated..
Thanks,
Pands
hi..
Here's a code i found in PHP.net for converting German letters ... Luckly, it works for my Arabic data ..
but I still have a problem even when using this cool function, which is converting arabic data coming from Excel file into readable data using the browser .. ( where the datat came from excel is displayed as '?' in the browser )PHP Code:
function convert_text($str)
{
$out = '';
for ($i = 0; $i<strlen($str);$i++)
{
$ch = ord($str{$i});
switch($ch)
{
case 252: $out .= chr(129); break; //u Umlaut
case 220: $out .= chr(154); break;//U Umlaut
case 228: $out .= chr(132); break;//a Umlaut
case 196: $out .= chr(142); break;//A Umlaut
case 214: $out .= chr(153); break;//O Umlaut
case 246: $out .= chr(148); break;//o Umlaug
case 223: $out .= chr(225); break;//SZ
case 228: $out .= chr(224); break;
default :{ $out .= chr($ch);}
}
}
return $out;
}
Any idea?