dbimport error 23103

[Chico]

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]

Post by Chico
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.

Post by Chico
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

Post by Chico
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.

[Ian Goddard]

Post by Chico
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?

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

[Chico]

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]

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

Subject: Re: dbimport error 23103
Date: Thu, 10 Jan 2013 08:28:24 +0100
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.
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list