home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT03055 Status: Geschlossen

BLOB CAST OF CHARACTER STRING HOST VARIABLES CAN CAUSE CODEPAGE CONVERSION
TO DATABASE CODEPAGE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
In DB2 For LUW version 10.5 Fix Pack 2 and earlier releases, a 
character string host variable cast to a BLOB data type would be 
converted to binary data without code page conversion from the 
client code page.  A change was made in DB2 For LUW version 10.5 
Fix Pack 3 that caused the host variable data to be converted to 
the database code page before the cast to BLOB occurs.  This 
occurs for both implicit and explicit casts. 
 
This was deemed an incompatible change and has been rolled back 
in version 10.5 Fix Pack 4. 
 
For example, assuming your application code page is 819 and your 
database code page is 1208, consider the following host 
variables: 
 
unsigned char r1[10] = {'ト'}; 
unsigned char r2[10] = {'チ'}; 
unsigned char r3[10] = {'ネ'}; 
 
If these values are input to a BLOB cast, in version 10.5 Fix 
Pack 2 and earlier releases the result (in HEX notation) of the 
BLOB cast for each host variable would be: 
 
r1 = 'E4  ' 
r2 = 'FC  ' 
r3 = 'EA  ' 
 
In version 10.5 Fix Pack 3, the result (in HEX notation) of the 
BLOB cast for each host variable would be: 
 
r1 = 'C3A4' 
r2 = 'C3BC' 
r3 = 'C3AA'
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 For LUW version 10.5 Fix Pack 3                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 For LUW version 10.5 Fix Pack 4.              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
The problem is fixed in DB2 For LUW version 10.5 Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.07.2014
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList