-
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.
-
Hisham Nagia
IT Manager For Development
Oracle Consultant - OCP
-
'?' in Arabic Data
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
Hisham Nagia
IT Manager For Development
Oracle Consultant - OCP
-
[QUOTE][i]Originally posted by hnagia [/i]
[B]Varchar2 will do the job [/B][/QUOTE]
-
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 ..
[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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|