DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: English/Arabic Database

  1. #1
    Join Date
    Feb 2001
    Posts
    3

    Cool

    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.

  2. #2
    Join Date
    Jun 2000
    Posts
    179

    Talking

    Varchar2 will do the job
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Feb 2001
    Posts
    13

    '?' 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


  4. #4
    Join Date
    Jun 2000
    Posts
    179

    Talking

    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

  5. #5
    Join Date
    Feb 2001
    Posts
    3
    [QUOTE][i]Originally posted by hnagia [/i]
    [B]Varchar2 will do the job [/B][/QUOTE]

  6. #6
    Join Date
    Feb 2001
    Posts
    13
    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

  7. #7
    Join Date
    Feb 2001
    Posts
    13
    I am unable to fix English/Arabic issue. Your help will be appreciated..

    Thanks,

    Pands

  8. #8
    Join Date
    Mar 2005
    Posts
    1
    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
  •  


Click Here to Expand Forum to Full Width