Exactly the same problem, on identical hardware, using identical databases, identical job design and identical software versions?
If not (and note that you have no knowledge of the original poster's environment), please begin a new thread.
Lookup Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
On a pedantic note, VarChar(1) is a waste of space. Char(1) should always be preferred, otherwise you're carrying the length prefix that has a constant value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Kind of an old wife's tale, Ray.
Not sure about other databases, but they store identically in Oracle. If you read down into the comments, you'll see that Tom (as in Kyte) says he "never" uses CHAR, interestingly enough.
Not sure about other databases, but they store identically in Oracle. If you read down into the comments, you'll see that Tom (as in Kyte) says he "never" uses CHAR, interestingly enough.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
True in DB2, true in dBase, true in SQL Server, true in Red Brick. As far as I am aware, also true in Sybase and Informix IDS. Oracle always tries to be different.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.