php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
30 - 2 = ?
Subscribe to this entry?

 
 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Sat Oct 25 09:00:02 2025 UTC