Data Import Problem on a Windows Server

[sporthorsebreeder +]

Hello
I have just imported a test database of listings into my business directory.

All went ok except I have noticed that the many categories and sub-categories have been added again even though they were already in the categories setup.

When the directory was installed the categories were imported in and the database is using UTF-8 collation/charset and its adding \r\n to the end of the entries for some reason.

I don't know a great deal about php and mySQL but I had a search on the internet and what I can gather is that the \r\n characters that are being added are because php and mySQL are being hosted on a Windows server.

I fould this on one website

If you are connecting from a Windows based machine, the Lines terminated by entry should normally be set to \r\n (the default suggested by phpMyAdmin). Windows uses both a carriage return character (\r) and a newline character (\n) to terminate the lines of text files. If your text file contains values for every field, listed in the same order as the fields are defined in the MySQL table, then the Column names box can be left blank. Finally, click Submit to upload the data file to the server and the records will be automatically appended to the table.

Has anyone else found this problem when importing data to a mysql database and what is the best way to fix it?

I am running
Windows Server 2003 running IIS v6
PHP Version 5.0.5
mysql 4.1.7
phpMyAdmin 2.6.4-pl4

Thanks for any help.
Hugh

[gregbatch +]

Not sure why you are importing categories. Categories shouldn't need to be uploaded with an import. Your data import file should mirror the products table, which references the categories in the category table numerically.

I'm not sure about the carriage return issue.

[sporthorsebreeder +]

Hi Greg
Thanks for your reply but the data import is not for 68Classifieds it is for my Business Directory another programme completely. That is why I posted it in Off Topic.
Cheers
Hugh

[gregbatch +]

Sorry about the misunderstanding.

[Lhotch +]

What method did you use to do the export and import?