php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #57218 LOB fields load in wrong charset
Submitted: 2006-09-04 07:36 UTC Modified: 2006-09-08 09:43 UTC
From: ms at e-kazan dot ru Assigned:
Status: Not a bug Package: oci8 (PECL)
PHP Version: 5.1.4 OS: RHEL AS4 U3
Private report: No CVE-ID: None
 [2006-09-04 07:36 UTC] ms at e-kazan dot ru
Description:
------------
When connect to db using CL8MSWIN1251 charset and fetch LOB fields they come in UTF-8. Latest CVS version tried.

Reproduce code:
---------------
<?
	$con = oci_connect('user', 'pass', 'db', 'CL8MSWIN1251');

	$stmt = oci_parse($con, "select lob_field from table where id = 1");
	oci_execute($stmt, OCI_DEFAULT);

	$r = oci_fetch_row($stmt);

	echo $r[0]->load(), '<br />';

	oci_close($con);
?>

Expected result:
----------------
LOB field in Windows-1251 charset

Actual result:
--------------
LOB field in UTF-8 charset

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-09-08 09:15 UTC] tony2001 at phpclub dot net
BLOB/FILE fields do not have any charset.
CLOB/NCLOB fields are read using charset specified when they were created.
 [2006-09-08 09:43 UTC] ms at e-kazan dot ru
I mean CLOBs in my report and it work fine using following CVS snapshot:
/.cvsignore/1.11/Sun Oct 10 16:09:59 2004//
/CREDITS/1.7/Tue Sep  6 21:42:26 2005//
/README/1.1/Tue Sep  6 19:31:59 2005//
/config.m4/1.62/Thu Jun 22 20:28:51 2006//
/config.w32/1.8/Mon May 22 04:17:24 2006//
/oci8.c/1.306/Wed Jun 28 15:03:16 2006//
/oci8.dsp/1.15/Wed Sep 28 22:31:45 2005/-kb/
/oci8_collection.c/1.7/Tue May 30 21:38:00 2006//
/oci8_interface.c/1.16/Mon Jun  5 07:34:00 2006//
/oci8_lob.c/1.14/Wed Jun  7 13:36:19 2006//
/oci8_statement.c/1.19/Wed Apr 12 19:22:12 2006//
/package.xml/1.15/Fri Jul  7 09:21:54 2006//
/php_oci8.h/1.40/Sun Jan  1 13:09:52 2006//
/php_oci8_int.h/1.16/Wed Jun  7 13:36:19 2006//
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Mon Apr 22 16:01:25 2019 UTC