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/yyyy
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 "<HTML><HEAD><TITLE>Nice Title, isn't
> it</TITLE></HEAD><BODY><PRE>\n";
> $conn = OCILogon("XXXXX", "YYYYY", "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 :
> <HTML><HEAD><TITLE>le titre</TITLE></HEAD><BODY><PRE>
> " " "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]