Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (128706 views)
- Error no. 2003: Can't connect... (58524 views)
- Error no. 1251: "Client does not support authentication..." (50543 views)
- Error no. 1045: "Connection denied..." (46253 views)
- SQLyog Version History (45078 views)
- Error No. 2005: Unknown MySQL server host... (33382 views)
- What is HTTP-tunneling? (32472 views)
- What Is SSH and SSH-tunneling? (28003 views)
- Why are Stored Procedures not created when I import ... (27059 views)
- Do I need PHP to use SQLyog with MySQL? ... (23937 views)
Latest FAQs 
- SQLyog Version History (2010-09-02 04:20)
- Do I need to replace the PHP tunneler file ... (2010-03-25 10:26)
- Data get truncated when importing a large CSV-file. (2010-03-18 12:30)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
Importing external data
I get "ERROR: 1136, Column count doesn't match value count at row ..." when using the Import External Data tool.
This is due to an ODBC-driver that uses the 'regional settings' of the client machine when generating the data stream from the source database. This can affect the use of the characters " , " (comma), " . " (punctuation) and " ; " (semicolon).
Among ODBC-drivers that does this, is the driver for the (in Europe in particular) popular Navision administrative software. This is probably implemented this way to support import to (Continental European) localized version of Microsoft Excel.
But as neither MySQL nor SQLyog uses this type of regional settings for any purpose, the stream of data generated is invalid with MySQL. If there is no setting available with the driver to bypass the regional settings, you will have to temporarily change the regional settings of the client machine to English while importing. The settings are available from Windows' Control Panel... Regional Settings.
Also some driver versions for Oracle and Microsoft SQL server use 'regional settings'. However most often it can be turned of in the driver settings. If not you should probably upgrade the driver.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
- What is and what is not imported by the SQLyog Import External Data Tool?
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
Last update: 2006-06-06 12:28
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ