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 Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: ms at e-kazan dot ru
New email:
PHP Version: OS:

 

 [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-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 18 20:01:30 2024 UTC