Skip to content
Advertisement

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.

Advertisement

Answer

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.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement