[prev in list] [next in list] [prev in thread] [next in thread] 

List:       rt-commit
Subject:    [Rt-commit] r2118 - in DBIx-SearchBuilder/trunk: . SearchBuilder
From:       jesse () bestpractical ! com
Date:       2005-01-19 22:21:22
Message-ID: 20050119222122.820BC4D8071 () diesel ! bestpractical ! com
[Download RAW message or body]

Author: jesse
Date: Wed Jan 19 17:21:21 2005
New Revision: 2118

Modified:
   DBIx-SearchBuilder/trunk/   (props changed)
   DBIx-SearchBuilder/trunk/Changes
   DBIx-SearchBuilder/trunk/SearchBuilder/Handle.pm
Log:
 r3890@hualien:  jesse | 2005-01-19T18:06:50.453718Z
 turn off utf8 flag on data just before inserting it, as that could make 
 DBD::Oracle 1.16 sad.
 
 


Modified: DBIx-SearchBuilder/trunk/Changes
==============================================================================
--- DBIx-SearchBuilder/trunk/Changes	(original)
+++ DBIx-SearchBuilder/trunk/Changes	Wed Jan 19 17:21:21 2005
@@ -2,6 +2,10 @@
 
 1.21
     - Oracle LOB handling caused us to corrupt item values on update.
+    - Just before inserting things into the database, turn off their utf8 flag.
+      The flag didn't have any positve impact _and_ it can take down
+      recent DBD::Oracle releases. (This is a new failure in DBD::Oracle 1.16)
+
 
 1.20 Tue Jan 18 08:24:15 EST 2005
     - Minor test suite fixes from Ruslan.

Modified: DBIx-SearchBuilder/trunk/SearchBuilder/Handle.pm
==============================================================================
--- DBIx-SearchBuilder/trunk/SearchBuilder/Handle.pm	(original)
+++ DBIx-SearchBuilder/trunk/SearchBuilder/Handle.pm	Wed Jan 19 17:21:21 2005
@@ -463,6 +463,9 @@
             delete $bhash->{'value'};
             $sth->bind_param( $bind_idx + 1, undef, $bhash );
         }
+        # Some databases, such as Oracle fail to cope if it's a perl utf8
+        # string. they desperately want bytes.
+         Encode::_utf8_off($bind_values[$bind_idx]);
     }
 
     my $basetime;
_______________________________________________
Rt-commit mailing list
Rt-commit@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-commit
[prev in list] [next in list] [prev in thread] [next in thread]