dbexport question?

Hi, I tried to import my database from one server to antoher using dbexport and then dbimport, but when I tried to use dbimport I realized that database.sql script file, which it's contained into database.exp directory, It has some characters that dbimport doesn't recognize in some fields. For example dbexport puts in a money field the default values like this: "NOTE: I only put the code segment example assuming that is creating a table..." ... FIELD_NAME MONEY (9,2) DEFAULT $0.00 ... ETC ... ... And this cause an error when I try to import the data base. And in the CHECK constraints in money fields, It Adds single quotes like this: ... CHECK( FIELD_NAME >= '0.00' )... ... And this generated an error again when I tried to use dbimport. Like additional information I'm using GLS parameters What can i do? Thank's in advance! Sent via Deja.com http://www.deja.com/

rafaelpadilla@my-deja.com wrote in message <957n6e$56l$1@nnrp1.deja.com>... >Hi, >I tried to import my database from one server to antoher using >dbexport and then dbimport, but when I tried to use dbimport >I realized that database.sql script file, which it's contained >into database.exp directory, It has some characters that dbimport >doesn't recognize in some fields. >For example dbexport puts in a money field the default values like this: > >FIELD_NAME MONEY (9,2) DEFAULT $0.00 ... ETC ... > >And in the CHECK constraints in money fields, It Adds single quotes >like this: >... >CHECK( FIELD_NAME >= '0.00' )... That's very strange! What are your definitions of the $DBMONEY and $DBFORMAT variables? Also (this advice on a hunch) check you are using the same $DBDATE on both sessions. I don't know anything about GLS, but perhaps you need to make sure the locales (in UNIX or the database or both) are identical. I'd make a very weak guess that the quotes around the number is because in some European languages, comma is used as a decimal separator? Is that correct? and perhaps dbexport needs to do it it's way and tries to protect itself (without success;-) Other environment variables that may be involved are: CLIENT_LOCALE SERVER_LOCALE (needed when the engine is started?) DB_LOCALE DBLANG LANG Check the manuals carefully for the definitions and possible problems.