Change format US-1252 to UTF-8

Ravi

HI All,

I am using Windows,
Database territory = US
Database code page = 1252
Database code set = IBM-1252
Database country/region code = 1
Database collating sequence = UNIQUE

now I want change to UTF-8 format in DB2 , data is in databases .
I am new to DB2, Pl. help me.

Thanks in Advance.

Ravi.

Nov 12 '05 #1

Subscribe Post Reply

8548

Phil Sherman

Code set (code page) is determined at database creation time and cannot
be changed (UDB Command Reference).

The only option I know would be to move the data to a new database. If
you have a mature application, this could cause issues changing all of
the access mechanisms used by applications. Two copies would allow you
to move to UTF-8 then move back to keep the database name.

If all access to the database is through clients that have a local alias
refering to the database name then moving the data to a new database
would require changing client configurations and would not involve
application changes.

Phil Sherman
Ravi wrote:

HI All,

I am using Windows,
Database territory = US
Database code page = 1252
Database code set = IBM-1252
Database country/region code = 1
Database collating sequence = UNIQUE

now I want change to UTF-8 format in DB2 , data is in databases .
I am new to DB2, Pl. help me.

Thanks in Advance.

Ravi.

Nov 12 '05 #2

Knut Stolze

Phil Sherman wrote:

Code set (code page) is determined at database creation time and cannot
be changed (UDB Command Reference).

The only option I know would be to move the data to a new database. If
you have a mature application, this could cause issues changing all of
the access mechanisms used by applications. Two copies would allow you
to move to UTF-8 then move back to keep the database name.

If all access to the database is through clients that have a local alias
refering to the database name then moving the data to a new database
would require changing client configurations and would not involve
application changes.

You could work with CATALOG DATABASE and UNCATALOG DATABASE without
affecting any applications/clients.

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena

Nov 12 '05 #3

Similar topics

Change in date format.

by: Miguel Orrego | last post by:

Hi, My asp pages that display data from databases have suddenly changed the date format they display from UK to US, i.e. 11/17/2001 for 17th Nov 2003. I have checked on the win2k sp3 server...

ASP / Active Server Pages

printf and format in c#

by: Mark | last post by:

Hi, how would I translate this to c#? char ttext; sprintf(ttext,"%2.2i %-.10s %8.3f",1,"Mark",123.24); 01 Mark<6spaces> 123.240 Thanks

C# / C Sharp

change the date format dd/mm/yyyy to m/d/yy

by: Claudia Fong | last post by:

Hi Is there a way to change a date format dd/mm/yyyy to m/d/yy? I have a textBox where the user should put a date, but no matter what format the user input dd/mm/yyyy or m/d/yy, I need to...

C# / C Sharp

DateTime format to ISO 8601 -- won't change???

by: Kathy Burke | last post by:

Hi, I've read every post I could find but still no luck on why this won't work for me. I have an aspx page (U.S. default, VB, .Net 1.1), where I use the following two variables: Dim varStartTime...

ASP.NET

How to change Date Format?

by: Shapper | last post by:

Hello, I have this code line: <%# DataBinder.Eval(Container.DataItem, "publication_date") %> Which displays the date and time as follows: 02-04-2005 0:00:00 How can I change the date...

ASP.NET

Visible property does not change

by: Marc Robitaille | last post by:

Hello, Hello, I developed a UserControl. It has funny behavior. It is composed of three controls. A texbox, a combobox and a button. There are three properties to indicate the visibility of...

Visual Basic .NET

How to change address location

by: andreas.w.h.k. :-\) | last post by:

How do I change the address location in the wsdl <wsdl:port name="SearchSoap12" binding="tns:SearchSoap12"> <soap12:address location="http://searchservices/engine/search.asmx" /> </wsdl:port> ...

.NET Framework

Bizzare error following change of _export to __declspec(dllexport)

by: Martin Pritchard | last post by:

Hi, Sorry for my ignorance, but I'm a bit new to C++. I've been handed over a C++ app written in VS2002 which I have to convert to VS2005. Apparently it's been written in a C style, but cannot...

.NET Framework

Change column of DateTime type to "long date" format

by: Curious | last post by:

Hi, I have a column in a grid defined as DateTime type. Currently, it's displayed in the format of "5/23/2007", for an example. It seems that it's using the default "short date" format. I...

.NET Framework

Change in XML format

by: ipramod | last post by:

Hi, I have an predefined XML format, lets say: <employee id="1111"> <name></name> <addr></addr> <salary></salary> </employee>

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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,...

General

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,...

C / C++

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...

Online Marketing