Change the DBLocate of an existing database
User asked if DBLocale can be changed on an existing Informix 11.70FC5 database without dbexport/dbimport. Experts confirmed there is no simple way—DBLocale cannot be changed directly because it affects data storage encoding. The only solution is to recreate the database with the new DBLocale, using dbexport/dbimport or optionally Enterprise Replication to migrate data to a new database with the desired locale.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
Is there an easy way to change the DBlocale of an existing database without
running dbexport/dbimport?
IDS version is 11.70FC5.
regards,
Nitin
Hello.
Unfortunately, dblocale must be chosen very carefully, just because of that
situations.
No, there is not any other simple way.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: nitin_maths@rediffmail.com
> Subject: Change the DBLocate of an existing database [30635]
> Date: Tue, 25 Jun 2013 09:11:09 -0400
>
> Hi,
>
> Is there an easy way to change the DBlocale of an existing database without
> running dbexport/dbimport?
>
> IDS version is 11.70FC5.
>
> regards,
> Nitin
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Ok, thanks Alexandre.
Hi Nitin,
You could use Enterprise Replication on a new server with target
database locale, and define template with --UTF8 option and replicate data
to new server using cdr sync/check replset command. This allows online
migration of data to target database locale.
Thanks & Regards,
Nagaraju
From: "NITIN MATHUR" <nitin_maths@rediffmail.com>
To: ids@iiug.org,
Date: 06/25/2013 08:12 AM
Subject: Change the DBLocate of an existing database [30635]
Sent by: ids-bounces@iiug.org
Hi,
Is there an easy way to change the DBlocale of an existing database
without
running dbexport/dbimport?
IDS version is 11.70FC5.
regards,
Nitin
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Nitin,
It is not possible, you must recreate the database with the new DBLocale.
Indeed, the DBLocale change the storage of the data in Informix.
By example :
- if you choose "UTF8", some special characters (by example, the symbol
money euro - "" ) will be encoded on 2 or 3 bytes.
- if you choose "CP1252", the same characters (euro - ) will be encoded
on 1 byte with another hex code.
Moreover, the hexadecimal code for the same character differ for each
DBLocale (en_US.8859, fr_FR.8859, cp1252, utf8 ...).
For this reason, you must recreate your database so that Informix can
convert your character data in the new DBLocale codeset.
Be careful, if you use "utf8" codeset and some special character, your
CHAR fields can be truncated, because the UTF8 characters can be stored
on 1 bytes for the normal character (a,b c, d ...) or on 2 or 3 bytes
for some special character or symbol.
Regards,
--
Franck Thomas
ConsultiX
franck.thomas@consult-ix.fr
http://www.consult-ix.fr
Téléphone : 33 (0) 1 39 12 18 00
Mobile : 33 (0) 6 78 81 09 33
Fax : 33 (0) 1 39 12 18 18
Le 25/06/2013 15:11, NITIN MATHUR a écrit :
> Hi,
>
> Is there an easy way to change the DBlocale of an existing database without
> running dbexport/dbimport?
>
> IDS version is 11.70FC5.
>
> regards,
> Nitin
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Thanks a lot Franck and Nagaraju for the response.