467,189 Members | 1,280 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

Problem inserting spanish characters in DB2 UDB

Hi

I am facing the problem while inserting the spanish characters in the
DB2 UDB v8.2 database. We are pulling the data from SQL server through
informatica and then pushing the same in the DB2 database. Codepage for
DB2 database is UTF-8, which is Unicode. Whenever it is encountering
any spanish charater it is giving the following error:

SQL0302N The value of a host variable in the execute or open statement
is too large for its corresponding use.
SQLSTATE=22001

Please help me.

Apr 3 '06 #1
  • viewed: 6714
Share:
2 Replies
Check this ...it might help you

http://www-128.ibm.com/developerwork.../dm-0506chong/

cheers...
Shashi Mannepalli

Apr 4 '06 #2
I've encountered this this problem which is a consequence of using
UTF-8. UTF-8 stores "standard" ascii using one byte per character. When
characters outside of the standard ascii set appear, they are stored as
16 bit unicode, occupying two character spaces. This requires that the
character (preferably varchar) columns be, worst case, defined twice as
large as the number of characters they will contain. Characters in some
languages will occupy more than 16 bits per character, requiring the
column definitions to be larger than two bytes/character.

UTF-8 data in columns also had interesting effects when using db2look to
transfer statistics data to another instance. The high2key and low2key
columns would not correctly transfer if the data values included UTF-8
16 bit characters.
Philip Sherman

pramod wrote:
Hi

I am facing the problem while inserting the spanish characters in the
DB2 UDB v8.2 database. We are pulling the data from SQL server through
informatica and then pushing the same in the DB2 database. Codepage for
DB2 database is UTF-8, which is Unicode. Whenever it is encountering
any spanish charater it is giving the following error:

SQL0302N The value of a host variable in the execute or open statement
is too large for its corresponding use.
SQLSTATE=22001

Please help me.

Apr 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by David A. Caballero J. | last post: by
2 posts views Thread by poisondart | last post: by
3 posts views Thread by Chip | last post: by
30 posts views Thread by Einstein30000 | last post: by
4 posts views Thread by =?Utf-8?B?TGVvbg==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.