Re: Community help on DB import seeked

Reinhard - thx, this helped with Q1 and Q2. Q3 is resolved as well. One of the combinations that is setting both DB_LOCALE and CLIENT_LOCALE to en_us.utf8 in order to load character data encoded as UTF-8 via dbimport command had worked fine already. I just did not 'see' the data via my JDBC (Squirrel) client. For this I needed to supply the properties jdbc:informix-sqli://127.0.0.1:9088/ ace:INFORMIXSERVER=ol_ids_1150_1;CLIENT_LOCALE=en_US.CP1252;DB_LOCALE=en_us.utf8 in the connect string. This is a prerequisite I had not experienced when I was once connecting with the same client to an Informix 9.xx server running on UNIX some time ago... Thanks, Gerrit Habichtsberg, Reinhard schrieb: > Gerrit > > > > > I am running IDS 11.5 on my personal XP box. When using the dbexport > > command > > I get an export (schema and data files) according to the > > documentation. > > > > Now I have been handed another DB export that allegedly has been > > created with > > the same 'dbexport' command as well. However this export does not > > contain > > { unload file name = xxx} clauses in the schema file. More then this > > the > > data files have an 'unl.a' extension. > > > > Question 1: Is this difference a version or an OS issue? Has the > > export been created with > > a different command maybe? > > You likely have an output of "dbschema" and some selfwritten database unload > tool which compresses *.unl files to unl.a > > > > > Question 2: Is there a difference in behaviour between the load and > > the dbimport command when it > > comes to loading of data files? > > > > Not really but have a look to the Migration Guide and GLS Support. > http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?tab=search&s > earchWord=Migration+Guide > > > Question 3: Would anybody have a hint on proper settings when it > > comes to creating a DB and loading associated data files that > > - have all sorts of characters (latin, bulgarian, greek) > > - which are properly encoded as UTF-8 within the files > > - which need to go to DB CHAR fields? > > > > The environment variables for DATE, LANGUAGE Settings etc. should be the > same with dbexport and dbimport. > > > > I have played around for two days now with different locale settings. > > Tried many combinations of > > DB, SERVER and CLIENT. Nothing seems to work......;-( > > What errors did you get? What did not work?