|
Problem IC85532
|
Status: Closed |
TO_CHAR CAN NOT HANDLE AM, MERIDIAN INDICATOR (MORNING OR EVENING) CORRECTLY IN MULTI-BYTE ENVIRONMENTS. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
Problem Reproducible Steps:
On AIX.
1. db2 terminate
2. db2stop
3. export TZ=xxx ; see below Results
4. export LANG=xxx ; see below Results
5. db2start
6. db2 create db <testdb>
7. db2 connect to <testdb>
8. db2 "values TO_CHAR('2010-12-28-16.52.39.274000','AM')"
==> should return 'PM' because 16.52 is PM.
==> but it returns 'AM' incorrectly in some cases.
9. db2 terminate
10. db2 drop db <testdb>
Results:
-----------------------------------------------------------
LANG/TZ|JST-9|EST5EDT|JST-9JSTDT|KORST-9KORDT|TAIST-8TAIDT
-----------------------------------------------------------
Ja_JP | AM | PM | AM | .. | ..
en_US | PM | PM | PM | .. | ..
C | PM | PM | PM | .. | ..
ko_KR | .. | .. | .. | AM | ..
zh_TW | .. | .. | .. | .. | AM
-----------------------------------------------------------
* On Windows 2008/ Windows 7 (Japanese multi-byte environment)
without setting TZ/LANG, it returns AM incorrectly.
* On AIX, if we use TO_CHAR('2010-12-28-16.52.39.274000',
'A.M.')" instead of 'AM', it always returns 'P.M.'
expectedly. This may be a workaround for some users.
* JST-9 is used in most of all AIX Japanese environment. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 UDB Version 10.2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 10.1 FixPack 2. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 10.1 FixPack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.07.2012
19.12.2012
19.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
