Phoca Cart -trouble importing csv

[vodka]

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

[Jan]

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

[vodka]

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

[vodka]

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

[vodka]

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

[Jan]

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

[vodka]

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

[vodka]

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

[Jan]

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

[vodka]

Can you please tell me how to find these symbols?