Phoca Forum

hello! please tell me how to solve the problem Phoca Cart when importing csv :

Incorrect string value: '\xxD0' for column `ssc_mdb10`.`kj959_phocacart_import`.`item` at row 51

occurs even if you unload and try to load without change the file.

Database type: mariadb10

Hi, this can be maybe some hidden characters, did you find it in the CSV, in which place it is located (e.g. maybe in some description area)?

Jan

what is meant by the word “item”? all the characters are standard, I can't find it.

What encoding is used to import and export a csv file?

I deleted this item completely from csv file, it stumbles on the following _phocacart_import`.`item` at row 188, and I deleted it, but it still gives the following message: Incorrect string value: '\xD1' .... _phocacart_import`.`item` at row 188

Hi, Phoca Cart does not change encoding, so normally, everything is stored in UTF-8. The question is if you can find such strings in the CSV?

Jan

Hi, the current database encoding is UTF-8mb4, if Phoca Cart saves CSV in it, why can't it load it back?

how to configure so that download occurs in utf8 format by filtering utf8mb4 characters?

Hi, Phoca Cart does not decide which encoding it will use, it just uses the default of Joomla - for both - database storing or file saving. Joomla methods are used to communicate with database or work with files.

Jan

Can you please tell me how to find these symbols?