Double byte (Japanese) chars from Oracle

[Anon]

I've been trying to read in some Japanese characters from an Oracle Database with no luck..

I'm using php 4.0.6 (since it claims to incorperate Japanese support) , oracle 8.1.6 client with apache..

The database tells me that the field is a VARCHAR2 and when I do a:

$SQL = "SELECT * FROM QMS_COMMENT";
ora_parse($DB, $SQL) or die;
ora_exec($D😎;
while(ora_fetch($D😎){
$str = ora_getcolumn($DB,4);
echo $str;
}
etc...

my output is always "???"'s
I've set my "NLS_LANG=japanese_japan.ja16euc" and tried everything that I could with with the mb_* commands that come with php 4.0.6 with no luck..

when I check the data out with sqlplus on my linux server it shows all of the data perfectly.. so I really don't know where the data is getting switched to ??'s..

If anyone has a simular setup for any multibyte characters please help! 🙂

Thanks!

[Anon]

try switching your browser encoding to whatever japanese encoding you use (EUC, @!#$-Jis, JIS, ISO...).

i usually get this ??? when i use a browser not compatible with jap. characters.

let me know when you get it right. tip: i encountered one critical test-case with PHP4 & MYSQL: try to read/write the japanese name
robinson (written in katakana). it used to mess around with the backslashes a lot.