Problem inserting spanish characters in DB2 UDB

pramod

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

Subscribe Reply

7307

Shashi Mannepalli

Check this ...it might help you

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

cheers...
Shashi Mannepalli

Apr 4 '06 #2

Phil Sherman

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

Similar topics

2063

Problem with simplified chinese

by: David A. Caballero J. | last post by:

I have a 3 layer system, SQL Server 2000 database, COM+ dll's (VC++ 6) and ASP frontend, this system has been in production for quite some time using english, spanish and portuguese versions. Now I've been asked to test the system to function with Simplified chinese. The development of the system was outsourced and we don't have communication with the company (some sort of legal problems i think). Now, I've been reviewing the code and...

ASP / Active Server Pages

1869

predefined entity set for spanish

by: poisondart | last post by:

Is there a predefined entity set for Spanish accents? I know that I could just easily make one, except that I intend to do this for other languages in the future, which may have more accents than Spanish. The closest to what I was expecting was this link: http://www.altheim.com/specs/charents.html ....but the link to the ent file is broken. What is the usual/preferred method that you employ to render special

.NET Framework

1316

Javascript String Termination Error Spanish Characters with ASP.NET

by: Garth17 | last post by:

This totally surprised me. I'm using IE 6. I built a really simple test.aspx page that had a javascript block in it like this: <script language=javascript src="spanish.js"></script> Inside the spanish.js I had 1 line that set a variable to a spanish character. var Test = "á";

ASP.NET

5129

File Read Spanish characters

by: Chip | last post by:

There is surprisingly little information on the various encoding options for reading a text file. I have what seems to be a very basic issue: I'm reading a text file that includes Spanish characters such as "ñ". When I read the file into a string, that character is missing. Encoding seems to be the culprit. File writers SHOULD begin a file with the BOM (Byte Order Mark) to let us know what encoding to read the file with, but most software...

ASP.NET

1417

Help loading Spanish characters in XmlDocument

by: JDeats | last post by:

I have an XML text file that has quite a bit of Spanish text contained inside, here's an example: <lib> <emp> <title>Encargado de la prevención de la tensión</title> </emp> </lib> When I load the xml into an XmlDocument object and try to extract the

C# / C Sharp

1352

Spanish language displays incorrectly

by: pziggs | last post by:

I have been working on a page in English, and today began tackling the Spanish version of the site. I'm curious because on the homepage (www.nuestracasa.com/esp/) it displays the spanish language characters (accented letters and other commonly used spanish characters) correctly, but on a subpage (www.nuestracasa.com/esp/buying-tips.php) it does not. Anyone have thoughts?

HTML / CSS

2855

mySQL Problem

by: Einstein30000 | last post by:

Hi, in one of my php-scripts is the following query (with an already open db-connection): $q = "INSERT INTO main (name, img, descr, from, size, format, cat, host, link, date) VALUES ('$name', '$img', '$descr', '$user', '$size', '$format', '$cat', '$host', '$link', '$date')" or die(mysql_error()); And when the query gets executed i get back the following error:

PHP

2537

Problem inserting german and french characters

by: kenia | last post by:

Hello everybody! I have a database that's supposed to hold data in different laguages, such as english, spanish, hebrew, german and french, but in priciple users may want to store info in any language. The charset I'm using is utf8 and collation utf8-general-ci, so that any character is correctly stored, however I've just found the following problem: -When I insert any special character of german language it doesn't get stored correctly, for...

MySQL Database

2609

Spanish characters problem

by: =?Utf-8?B?TGVvbg==?= | last post by:

Hi everybody. I am using streamreader to show spanish .htm page on my website. Unfortunately those spanish characters that have stresses on top (like: Ã“,Ã¡, ....) do not show correctly. Is there any way to overcome this problem?

ASP.NET

9728

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9605

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10648

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10389

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7670

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6890

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5692

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3867

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3018

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General