Re: Community help on DB import seeked

Gerrit sorry no expierence with the jdbc topic. Perhaps some of the technical experts - not the marketing experts :-> - may answer? Regards Reinhard. > > > 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? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list