Search code examples
sqlplsqlarabicplsqldeveloper

PL/SQL arabic displayed as?

When I query for data that have arabic text in PL/SQL Developer, It is showed as question marks (????).

I am sure the data is correctly stored in DB because it shows on website properly, also on the server.

So I think it is a problem related to my PL/SQL Developer (v8.0.4.1514).

  • Is there any way to change how PL/SQL Developer shows/encodes arabic text?

  • How to check in what format/encoding the arabic text is stored?

My question might be missing some details, So Just ask me and also keep in mind that I am very beginner in PL/SQL and in SQL.

Thank you.

Solution

  • I found a solution (which might also work with other languages that shows as '????')

    I changed the NLS_LANG in registry to AMERICAN_AMERICA.AL32UTF8

    (I found 3 NLS_LANG's in registry, check with each one or just change them all like I did.)

    then restarted PL/SQL developer, test a query and arabic text is showing normally.

    Thank you all.