473,811 Members | 3,057 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to handle utf-8 char in db2 export

Hi,
I am using udb version 8 fixpack 12 installed on Linux.
I need to move a schema from one db to another. All tables in the
target and source schemas are created using 'CCSID UNICODE'.
I used db2move export command from the db2 client on Windows XP.
However, when I import the data into the target schema, I noticed some
special characters were replaced by a right-arrow character.
What do I need to do to keep the data intact during the transfer?

Thanks in advance.

Tom
Mar 10 '08 #1
1 9690
to*****@hotmail .com wrote:
Hi,
I am using udb version 8 fixpack 12 installed on Linux.
I need to move a schema from one db to another. All tables in the
target and source schemas are created using 'CCSID UNICODE'.
I used db2move export command from the db2 client on Windows XP.
However, when I import the data into the target schema, I noticed some
special characters were replaced by a right-arrow character.
What do I need to do to keep the data intact during the transfer?

Thanks in advance.

Tom
I believe that by default DB2 converts data to the client application
codepage. This includes the output of export. Try setting the DB2CODEPAGE
environment variable to 1208 before doing the export. It may also have to
be set prior to import or load.

When using UTF-8, even when using characters that convert correctly you can
get import/load errors due to truncation if the client is not running with
the correct codepage. E.g. Some characters may correctly change from
multi-byte to single byte and a char column will get padded with blanks.
When importing/loading the reverse happens but the blanks may not be
removed and an error is the result.
Colin
Mar 10 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
11785
by: js | last post by:
Hi, hwo to use ASP to handle chinese characters output? I have try two ways: 1. store the string in a text file(unicode file) 2. store the string in an access database The first method got an error: Active Server Pages error 'ASP 0239' Cannot process file UNICODE ASP files are not supported.
0
2717
by: Samuel Fung | last post by:
Hi all, Can ASP retrieve UTF-8 encoded data in query string properly, when used with IIS 5.0 on Windows 2000 Pro/Server? With some trial and error, it seems that adding the directive @CodePage = 65001 to an ASP page makes the ASP page decode UTF-8 data in query string properly. Without the directive, Request.QueryString(var) returns garbled data. With the directive, Request.QueryString(var) decodes UTF-8 encoded data properly. (I tried
1
1336
by: Kelvin | last post by:
Hi, there: I want to know how MSXML handles Asian languages like Chinese and Korean? Bet Regards, Kelvin
1
2135
by: Jack | last post by:
Hi, I am working on a asp page where I am opening a recordset object using an Access stored query named "GMISExpenseCombo". I have to use this resultset with various fields in the page. Howeve,r this query consists of 1000 unique records. The way this query is used in a different Access application is using its parameter to pull a distinct record. In ASP, is there any way to use a Access parameter query to extract record of choice? Or,...
1
1750
by: Mark | last post by:
Assume you have a simple HTML form that submits its form results to a .aspx page. The receiving .aspx page processes the values sent by the form. If the form data contains an accented character (ex., Ángel with an accent over "A"), the REQUEST object appears to loose the globalization, and nukes any extended ascii characters. Is there a way to avoid this? In the examples below, the resulting string is "ngel", without the A and accent....
1
2249
by: Steve | last post by:
I want to ask if .NET cannot handle WSDL with exception <wsdl:fault> element? <wsdl:fault name="CreditCardWizardException"> <soap:fault name="CreditCardWizardException" use="encoded" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="http://CreditCardwizard.wws" /> </wsdl:fault> I am using VS.NET and generate the client-side proxies, but it seems
10
13981
by: lamxing | last post by:
Dear all, I've spent a long time to try to get the xmldocument.load method to handle UTF-8 characters, but no luck. Every time it loads a document contains european characters (such as the one below, output from google map API), it always said invalid character at position 229, which I believe is the "ß" character. Can anyone point me to the right direction of how to load such documents using the xmldocument.load() method, or...
4
2603
by: Rui Maciel | last post by:
I want to support Unicode on a pet project of mine (small markup language parser). I've read a bit about Unicode (didn't delved beyond the basics) and I searched for some info on how to support Unicode on C programs. Unfortunately I wasn't able to find articles that could be considered more than loose ends, small blog entries and side remarks, never delving too much into specifics. From what I gathered, the two main methods (based on...
7
2201
by: billsahiker | last post by:
if an xml file specifies an encoding, e.g., utf16, do xml browsers and xml editors read and verify each character in the file to make sure it is utf16? and throw an error if it is not, or. do they do an automatic filtering/converting to utf16, or do they do something else? Do they default to utf8 if the xml file does not specify an encoding? Bill
13
4029
by: =?Utf-8?B?Um9nZXIgTWFydGlu?= | last post by:
This is a follow-up to my post "Silverlight video doesn't work when file is streamed from handler in ASP.net" at http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.dotnet.framework.aspnet&mid=e9a38d03-83a8-41fc-8950-5ee60d2a18a5. I have a web site under .NET 2.0 that renders videos using the Silverlight media player. When I stream the video file (.wmv) to the browser via a hard-coded link to the file,...
0
9605
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,...
0
10647
Oralloy
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...
0
10384
jinu1996
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...
0
10130
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7667
isladogs
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...
0
6887
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();...
0
5553
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5692
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4338
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.