hi folks ,
I have a shell script which contain SQL query that dump some data from the DB in arabic and this data is written to a file in unix machine but the problem that the arabic data is appear like ??????????|111|???????? even when I move it to my windows XP machine.
Any one have an Idea what I have to do.
You set (or your DBA set) NLS to Arabic, right?
You set the locale for your process running the SQL to Arabic? UTF16 at least. Since you mention Windows I'm assuming unicode:
A Quick Primer On Unicode and Software Internationalization Under Linux and UNIX
make sure your sql query is set the character set correctly either windows-1256 (cp1256) or utf-8. others might use latin1 as default for arabic
pass --default-character-set=XXXXXX to your mysql prompt line