dbimport error 23103

Chico

unread,

Jan 9, 2013, 3:08:13 AM1/9/13

to

Hello,

I need help with this error.

The error occurs when I try to import database to Informix 11.50 with
db_locale = en_us.8859-1. The database is from Informix 9.40 and
db_locale = en_us.cp1252.

On the net I found that the problem was db_locale, but no procedure for
the solution of problems.

Is it possible (and how) to set the dbimport syntax to change db_locale
while importing db?

Thanx in advance.

Jonathan Leffler

unread,

Jan 9, 2013, 8:21:47 AM1/9/13

to Chico, Informix List - IIUG

On Wed, Jan 9, 2013 at 12:08 AM, Chico <a...@aa.com> wrote:

I need help with this error.

finderr -23103 says:

-23103 Code-set conversion function failed due to an illegal sequence or
invalid value.

Illegal or invalid characters occur in the character string. The
program could not execute the code-set conversion on the characters
that this string contains. Reexamine the input string for illegal or
invalid characters and reexecute the program.

The error occurs when I try to import database to Informix 11.50 with
db_locale = en_us.8859-1. The database is from Informix 9.40 and
db_locale = en_us.cp1252.

CP1252 and ISO 8859-1 both have character mappings for each byte in the range 0x00..0xFF. They are not identical, but the differences seldom matter.

Where are you trying to do the import (Unix, WIndows)? Did you convert line endings from Windows (CRLF) to Unix (NL, aka LF) when you moved the files to Unix? FTP text mode transfer will do that. So will commands such as dos2unix or dtou or tr or ...

On the net I found that the problem was db_locale, but no procedure for
the solution of problems.

Is it possible (and how) to set the dbimport syntax to change db_locale
while importing db?

Since the DB locale is not recorded in the exported data, all that should be necessary is to set:

CLIENT_LOCALE=en_us.8859-1 DB_LOCALE=en_us.8859-1 dbimport ...

That is, specify the new locale, claim that the data is provided in the new locale, and go.

--
Jonathan Leffler <jonathan...@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be amused."

Ian Goddard

unread,

Jan 9, 2013, 11:15:15 AM1/9/13

to

Google is your friend. Look for GLS User's Guide.

--
Ian

The Hotmail address is my spam-bin. Real mail address is iang
at austonley org uk

Chico

unread,

Jan 10, 2013, 2:28:24 AM1/10/13

to

Thanx for replays.

Unfortunately, I have a little knowledge in the administration of
Informix. I didn't do any conversation, just standard export and import
database.
I will try to apply these tips and find GLS User's Guide.
The last solution is to create another Informix instance on the server,
where I would just import db with en_us.cp1252.

Alexandre Marini

unread,

Jan 10, 2013, 6:02:20 AM1/10/13

to inform...@iiug.org

Ok Chico, for administration purposes, if you don´t want to be worried about some command lines, I would suggest you to try two excelent softwares:
1) OAT - OpenAdmin Tool (provided and supported by IBM - free of charge)
2) AGS ServerStudio - a more professional tool, trial for a period, and limited, but if you can pay for a license, it´s a best option. Several good source of tools for monitoring and administer Informix instances.

Oat has a forum inside our IIUG website, for helping you to install and use it.
AGS has its own support team, easy to install and fully documented.

Make your choice, and if you need some assistance, you can ask us.

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

> _______________________________________________
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list