+ Reply to Thread
Results 1 to 8 of 8

String data right truncation. SQLSTATE=22001

  1. String data right truncation. SQLSTATE=22001

    When you get the message :

    String data right truncation. SQLSTATE=22001

    What is usually the source of the problem?

    Might a null value assigned get a PreparedStatement's
    setString method be the problem?

    Thanks.


  2. Re: String data right truncation. SQLSTATE=22001

    Usually it is a character string that is too long.
    Can also be assinging a dat/time/timestamp value to a host variable that is
    not big enough.

    --
    Message posted via DBMonster.com
    http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1

  3. Re: String data right truncation. SQLSTATE=22001

    Usually it is a character string that is too long.
    Can also be assinging a dat/time/timestamp value to a host variable that is
    not big enough.

    --
    Message posted via DBMonster.com
    http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1

  4. Re: String data right truncation. SQLSTATE=22001

    Usually it is a character string that is too long.
    Can also be assinging a dat/time/timestamp value to a host variable that is
    not big enough.

    --
    Message posted via DBMonster.com
    http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1

  5. Re: String data right truncation. SQLSTATE=22001

    Usually it is a character string that is too long.
    Can also be assinging a dat/time/timestamp value to a host variable that is
    not big enough.

    --
    Message posted via DBMonster.com
    http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1

  6. Re: String data right truncation. SQLSTATE=22001

    Usually it is a character string that is too long.
    Can also be assinging a dat/time/timestamp value to a host variable that is
    not big enough.

    --
    Message posted via DBMonster.com
    http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1

  7. Re: String data right truncation. SQLSTATE=22001

    Usually it is a character string that is too long.
    Can also be assinging a dat/time/timestamp value to a host variable that is
    not big enough.

    --
    Message posted via DBMonster.com
    http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1

  8. Re: String data right truncation. SQLSTATE=22001

    Usually it is a character string that is too long.
    Can also be assinging a dat/time/timestamp value to a host variable that is
    not big enough.

    --
    Message posted via DBMonster.com
    http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1

+ Reply to Thread