Re: Load / unload error - "Number of values in load files is not egal ..."

Posted in 2005

Topics: Migration, Import/Export & Data Conversion, Internationalization & Character Sets

Bob — Mon, 14 Feb 2005 12:19:17 +0100 — source: Usenet: comp.databases.informix

in fact the wrong character are stored in text field, for exemple one user save a message like 'client payed an account of 100 euro' and instead of writing euro used the euro symbol. Fred "Valeriy Kravchuk" <openxs@ipnet.kiev.ua> a 'crit dans le message de news: cupvf2$28km$1@news.dg.net.ua... >> i have some character (like the euro symbol and others) that are present > in >> the output file but they generate an error where i try to load the file. > > Looks like you have to set DBMONEY environment variable explicitly (to > something like ., set DBMONEY=. if you are on Windows or DBMONEY=.;export > DBMONEY on UNIX) before unload, and exactly to the same value before load. > Are your environment settings (DB_LOCALE etc.) the same for original and > backup databases? > > Currency symbols are added to the MONEY columns values "by default". > > May be, explicit DBDATE and/or GL_DATE settings are needed too. > >

↪ replying to Bob

Valeriy Kravchuk — Mon, 14 Feb 2005 13:37:34 +0200 — source: Usenet: comp.databases.informix

> in fact the wrong character are stored in text field, for exemple one user > save a message like 'client payed an account of 100 euro' and instead of > writing euro used the euro symbol. So, your user entered euro symbol in the original database successfully, but you can not load it into your backup database, aren't you? It should be a problem with locales. Please, give us the values of DB_LOCALE and CLIENT_LOCALE environment variables for both environments.

↪ replying to Valeriy Kravchuk

Bob — Mon, 14 Feb 2005 14:19:17 +0100 — source: Usenet: comp.databases.informix

client_locale = EN_US.CP1252 bb_locale = EN_US.8859-1 Those settings were set by the company which sold us our software ... this company does not exist anymore :-( so i don't know why those settings were chosen or if i can modify them. Fred "Valeriy Kravchuk" <openxs@ipnet.kiev.ua> a 'crit dans le message de news: cuq2ki$29kj$1@news.dg.net.ua... >> in fact the wrong character are stored in text field, for exemple one >> user >> save a message like 'client payed an account of 100 euro' and instead of >> writing euro used the euro symbol. > > So, your user entered euro symbol in the original database successfully, > but > you can not load it into your backup database, aren't you? It should be a > problem with locales. Please, give us the values of DB_LOCALE and > CLIENT_LOCALE environment variables for both environments. > > >