How to change the character set of a database?

[osman7king]

hi all:

I have Embarcadero DBArtisan 8.1.5 installed on XP professional and have Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 on a the server which I connect.

I have Arabic characters in my DB, when I view this data in DBArtisan or SQL *Plus, it appears like ( U„???© ?§U†UƒU„U??²U?? © ???®?µ?µU??© )
but when I view it by Php language it appears correctly (in Arabic).

the character set of the database is 'UTF8'.
the the value of NLS_LANGUAGE parameter is 'ARABIC'.

may someone help me please.....
thanks.

[amitpatel66]

you will need to change the characterset at database level.
But why you need to do so? From your php page, you are able to see the data correctly isnt it?

[osman7king]

thank you for your answer....
1.but as I know the charaterset 'UTF8' can deal with any characters(like arabic).


2.I need to view the data (arabic data) correctly in DBArtisan too, not just in php page, and when I order the data in php page by a column which has arabic data, the ordering will not be correct.(I don't know why).

thanks.