English/Arabic Database

[Anis]

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.

[hnagia]

Varchar2 will do the job

[s_pandian]

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

[hnagia]

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

[Anis]

[QUOTE][i]Originally posted by hnagia [/i]
[B]Varchar2 will do the job [/B][/QUOTE]

[s_pandian]

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

[s_pandian]

I am unable to fix English/Arabic issue. Your help will be appreciated..

Thanks,

Pands

[dello]

hi..

Here's a code i found in PHP.net for converting German letters ... Luckly, it works for my Arabic data ..

[PHP]
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;
}
[/PHP]

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 )

Any idea?