Import data SQL negative BDD

Asked By amina_baby 0 points N/A Posted on - 10/01/2011

I try to import data into my database via the Loader in my base. I want to import CSV data has negative (with a "-" before the number). When I import, I have the following error message:

"Invalid character value for the specification of the case."

It seems that the system does not handle negative data, because when I took the numbers with a "-" before the import went smoothly.

Note that I'm new to SQL.

Thank you in advance for your answers.

• Status: Open
• Question Views: 849
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Alber grower 0 points N/A #84779

Import data SQL negative BDD

You said that you import data using CSV file and a negative value is not accepted by the import, then you must be having problems with the kind of data type that you set for that specified value.

Those dashes are accepted by the excel and should have no problem with it. It must only be with the settings. I tested what you are trying to say but I have a smooth import and there is nothing wrong with my import.

Note: If you use SQL, make sure to have a single quote for number and double quote text. This is a basic in writing SQL.

About Alber grower

Questions
0

Answers
370

Best Answers
106

• Vote Up 0 Vote Down

• Posted on - 10/03/2011
• Question Category: Database