Re: Change Database Locale
This is a multi-part message in MIME format.
--------------6F3EBD43D5BB1567C47F1F57
Content-Type: text/plain; charset=iso-8859-1
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Content-Transfer-Encoding: 8bit
The official way is to dbexport the database,
then set DB_LOCALE and CLIENT_LOCALE,
then dbimport your database again.
Be carefull about dates and decimal point. Usually you can set DBDATE
and DBMONEY before you export to be sure that dates and decimal point
correspond to the locale you want to import under.
If you don't set CLIENT_LOCALE and DB_LOCALE your database will be
localized to en_us.8859-1.
You can look it up with SELECT * FROM systables WHERE tabid in (90, 91);
The unofficial way (be very carefull) is to directly update the
systables table, with something like
UPDATE systables
SET site = 'de_de.819'
WHERE tabid in (90, 91);
After this you must rebuild indexes on NCHAR and NVARCHAR columns.
regards
claus samuelsen
Daniela Lemm wrote:
> Hey,
>
> we are working with Informix 7.22. My Problem is that the Locale of
> the
> Database is incorrect and I have to change it.
> I' ve tried this with Backup and Restore but it didn't work, after
> changing the Locale Keys in the Windowsregistry.
>
> Can I set the Locale in an another way?
>
> Thanks
>
> Dani Lemm
>
>
> -------------------------------------------------------------------------------------------------------------
>
> Daniela Lemm <lemm.cgn@sni.de>
> Siemens Nixdorf Business Services
>
> Daniela Lemm
> Siemens Nixdorf Business Services <lemm.cgn@sni.de>
> Colonia Allee 3 Work: 0221/679-2134
> K'ln Fax: 0221/679-1772
> 51067 Home: 02304/70601
> Germany Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Lemm
> First Name Daniela
> Version 2.1
--------------6F3EBD43D5BB1567C47F1F57
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Claus Samuelsen
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Claus Samuelsen
n: Samuelsen;Claus
org: Avenir Danmark A/S
adr: Gydevang 22 B;;;DK-3450 Aller'd;;;Denmark
email;internet: csa@sysdeco.dk
title: Systems Manager
tel;work: +45 4814 3000
tel;fax: +45 4814 3011
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard
--------------6F3EBD43D5BB1567C47F1F57--