Ok, thanks all for the advices.
The problem is linked with the NLS parameters.
Here are my database related param:
NLS_LANGUAGE=French
NLS_TERRITORY=France
NLS_DATE_LANGUAGE= french
NLS_DATE_FORMAT = dd/mm/
I change my query : select CHAR_COL . into select
convert(CHAR_COL, 'US7ASCII')
and it works.
It's not really nice but anyway it's a good first step.
Thanks again
Emmanuel Nectoux
Is source and output from one try? because the number of rows doesn't match
a problem could be the NLS-SETTINGS of your DB,
maybe they are set to a character set that uses
2 Bytes per char.
Or yust PHP has a problem to handle CHAR - columns.
maybe you can overcome that with some type conversions.
Either try something like to_char () or substring () in SQL:
select to_char (colname) //i#m not sure if that works
select substr (colname,1) // or zero, don't know if character counting
starts with 0 or 1
or
cast the result values :
$col_1 = (string) ociresult($stmt, "CHAR_COL");
mk
The "Hello" example (" H e l") comes from the sourcecode of
my browser.
What's strange is that the two browsers (Netscape 4.03Fr and
IE 5.0) have different source code for the same page.
It do seems that each CHAR that I manage to fetch is coded
with two places (in IE).
I tried the following code for example with the same result
?php
print "HTMLHEADTITLENice Title, isn't
it/TITLE/HEADBODYPRE\n";
$conn = OCILogon("X", "Y", "ZZZBASEZZZ");
$stmt = OCIParse($conn, "select CHAR_COL,
OTHER_DATATYPE_COL from CODE_FICHIER");
OCIExecute($stmt);
// I fetch the five first rows
for ($i = 0; $i 5; $i++) {
ocifetch($stmt);
$col_1 = ociresult($stmt, "CHAR_COL");
$col_2 = ociresult($stmt, "OTHER_DATATYPE_COL");
echo("\"$col_1\"\t\"$col_2\"\t\n");
}
echo ("/PRE/BODY/HTML");
?
The html source is :
HTMLHEADTITLEle titre/TITLE/HEADBODYPRE
" " "308"
" A B C""626"
" " "702"
" A A N""1108"
" " "1109"
" 7 5 1""1112"
"" ""
"" ""
/PRE/BODY/HTML
I will have a look at the HTTP header (Content-Language or
mime-type...), who knows
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
