Strange characters in product description, can you help?

site address :
http://unigall.nazwa.pl/index.php?main_page=index&cPath=34

looking forward for any help :wacko:

With the templatemonster template you are using there isn't anyway we can help. You or someone has modified some code somewhere and left a php code ascrew.

I know this template and it is not the fresh install nature to do this so I would suggest replacing tampered files with a new unaltered by you one.

Look in the Tutorials and FAQs regarding the UTF-8 encoding; your configure.php file and your database don't agree on the encodings.

doubt it is UTF it is on only one sub catagorie. not the whole site.

Did you manually enter names & descriptions?

or

Did you copy names & descriptions from another program?

It is usually encoding issue, especially when copying and pasting from another program or importing in bulk.

Is your data setup for UTF8?

rbarbour:

Did you manually enter names & descriptions?

or

Did you copy names & descriptions from another program?

I did enter descriptions manually, and tried it again still same problem. Any other suggestions?

CoolCarPartsOnline:

It is usually encoding issue, especially when copying and pasting from another program or importing in bulk.

Is your data setup for UTF8?

What you mean by "data setup for UTF8" ? in configure.php file in Admin and Includes looks like that:

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/xxxx/xxxx/xxx');

define('DB_CHARSET', 'utf-8');

usernamenone:

With the templatemonster template you are using there isn't anyway we can help. You or someone has modified some code somewhere and left a php code ascrew.

I know this template and it is not the fresh install nature to do this so I would suggest replacing tampered files with a new unaltered by you one.

I did and unfortunately no change what so ever... dont know where to look more?? :no::no:

lat9:

Look in the Tutorials and FAQs regarding the UTF-8 encoding; your configure.php file and your database don't agree on the encodings.

I looked at that post and checked configure.php , looks like that:

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/unigall/ftp/cache');

define('DB_CHARSET', 'utf-8');

:frusty::frusty:

It isn't your charset it is just that one sub catagorie. find it and edit the name and discription or delete it.

usernamenone:

It isn't your charset it is just that one sub catagorie. find it and edit the name and discription or delete it.

Its not just that sub cat. I tried to edit it and delete it or making new one and still same problem :lamo: :censored:
ANY ONE KNOW WHAT TO DO???

just a suggestion but check you db collation

rbarbour:

just a suggestion but check you db collation

what you mean by that?

rbarbour:

just a suggestion but check you db collation

YES you are right all DB collation is in latin2_general_ci
what to do now?

Hope this helps

Older versions of Zen Cart does not use UTF-8 by default.

You can follow this guide to make your own website UTF-8 compliant: http://www.srw2d.com/sites/default/file ... V1.3.8.pdf

Existing websites will need to go into PHPMYADMIN and change the collation of the database and tables to utf8_unicode_ci. Do the same for all of the columns in the tables that you need to be able to store UTF-8 encoded characters.

Or you can use the **MySQL charset converter** for Zen Cart by DrByte in the free downloads since the posted link seems to be invalid.

rbarbour:

Hope this helps

Older versions of Zen Cart does not use UTF-8 by default.

You can follow this guide to make your own website UTF-8 compliant: http://www.srw2d.com/sites/default/file ... V1.3.8.pdf

Existing websites will need to go into PHPMYADMIN and change the collation of the database and tables to utf8_unicode_ci. Do the same for all of the columns in the tables that you need to be able to store UTF-8 encoded characters.

Hi Guys

So I tried my best to research my issue and to be honest have tried everything everyone has mentioned on the subject and after breaking the site a few times and restoring it or changing code back have still gotten nowhere.

I installed a fresh Zencart v1.5.6c, made some changes here and there. Added Easy Populate 4.0.36.ZC - 07-05-2016 and started uploading CSV's.
I noticed after importing the CSV there are alot of red question marks inside a red diamond in the admin.

The front end cuts off any further characters of product name and specs after this symbol.

http://www.gotitall.co.za/index.php?...oducts_id=7860

I read it had to do with CHAR sets and changing database to UTF8 and I have tried all of this, without success.
I also change the code in various files as per different possible solutions.

I have copied the original specs from supplier pricelists in Notepad++ and can see that some of the original character is degrees, plus and minus ± etc etc.
For some reason I am unable to get Zencart/EasyPopulate/Database to see these characters.

Below is an example of the symbol that is replacing the special character.
Any help would be greatly appreciated.

Import Results

Filename: TarsusDistributionEpsonHardwareResellersPricelist02July2020.csv

WARNING! - Model: V11H921540 P390 - Products name: "EB-1480Fi, Projectors, Ultra short distance, Full HD, 5.000�lumen- 3.500�lumen�(economy), 5.000�lumen - 3.500�lumen�(economy), Over 2.500.000�: 1, USB 2.0 Type A (2x), Powered USB, RS-232C, Ethernet interface (100 Base-TX / 10 Base-T), Wireless LAN IEEE 802.11a/b/g/n/ac (WiFi 5), Wi-Fi Direct, VGA in (2x), VGA out, HDMI in (3x), HDMI out, Component in, Miracast, Stereo mini jack audio out, Stereo mini jack audio in (3x), Microphone input, Finger-touch interface, Multi-Touch interface, USB 2.0 Type B (2x), Sync. in, Sync. out, 9,8�kg, 16�W, Stereo:�Stereo, Linux, Mac OS 10.10.x, Mac OS 10.7.x, Mac OS 10.8.x, Mac OS 10.9.x, Ubuntu 14.10, Ubuntu 15.04, 2 x Pen tip(Teflon), 4 x Pen tip(Felt), CD Manual, Cable cover, Interactive pens, Lens cap, Pen Holder/Stand, Power cable, Remote control incl. batteries, Replacement pen tips" exceeds max. length: 64
UPDATED! - Model: V11H921540 P390 | 1 | | EB-1480Fi, | EB-1480Fi, | | | | | 71794.492 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H942940 P390 - Products name: "EB-L1050U, Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 7.000�lumen- 4.900�lumen�(economy) in accordance with IDMS15.4, 7.000�lumen - 4.900�lumen�(economy) in accordance with ISO 21118:2012, Over 2.500.000�: 1, USB 2.0 Type B (Service Only), RS-232C, WLAN (2x), VGA in, DVI in, HDMI in, BNC in, HDBaseT, Stereo mini jack audio out, Stereo mini jack audio in (3x), Ethernet interface (100 Base-TX / 10 Base-T), Wireless LAN IEEE 802.11a/b/g/n (optional), VGA out, HDMI (HDCP 2.2)" exceeds max. length: 64
UPDATED! - Model: V11H942940 P390 | 1 | | EB-L1050U, | EB-L1050U, | | | | | 73994.412 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H940840 P390 - Products name: "EB-L1075U, Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 7.000�lumen- 4.900�lumen�(economy) in accordance with IDMS15.4, 7.000�lumen - 4.900�lumen�(economy) in accordance with ISO 21118:2012, Over 2.500.000�: 1, Stereo mini jack audio out, VGA out, RS-232C, HDMI (HDCP 2.2), HDMI in, WLAN (2x), HDBaseT, VGA in, USB 2.0 Type B (Service Only), Stereo mini jack audio in (3x), DVI in, Ethernet interface (100 Base-TX / 10 Base-T), BNC in, Wireless LAN IEEE 802.11a/b/g/n (optional), 16,9�kg, CD Manual, Cable cover, Lens cap, Power cable, Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11H940840 P390 | 1 | | EB-L1075U, | EB-L1075U, | | | | | 101513.972 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H940940 P390 - Products name: "EB-L1070U, Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 7.000�lumen- 4.900�lumen�(economy) in accordance with IDMS15.4, 7.000�lumen - 4.900�lumen�(economy) in accordance with ISO 21118:2012, Over 2.500.000�: 1, HDBaseT, VGA in, USB 2.0 Type B (Service Only), Stereo mini jack audio in (3x), DVI in, Ethernet interface (100 Base-TX / 10 Base-T), BNC in, Wireless LAN IEEE 802.11a/b/g/n (optional), Stereo mini jack audio out, VGA out, RS-232C, HDMI (HDCP 2.2), HDMI in, WLAN (2x), 16,9�kg, CD Manual, Cable cover, Lens cap, Power cable, Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11H940940 P390 | 1 | | EB-L1070U, | EB-L1070U, | | | | | 101513.972 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11HA16140 P390 - Products name: "EB-L1495U Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 9.000�lumen- 6.300�lumen�(economy) In accordance with IDMS15.4, 9.000�lumen -6.300�lumen�(economy) In accordance with ISO 21118:2012, 2.500.000�: 1, Stereo mini jack audio in (3x), Stereo mini jack audio out, HDBaseT, BNC in, HDMI in, DVI in, VGA out, VGA in, Ethernet interface (100 Base-TX / 10 Base-T), RS-232C, USB 2.0 Type B (Service Only), HD-SDI, Wireless LAN b/g/n (2.4GHz) (optional), 23,8�kg, CD Manual, Cable cover, VGA cable, Power and signal cable (3 m), Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11HA16140 P390 | 1 | | EB-L1495U | EB-L1495U | | | | | 207058.732 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11HA16040 P390 - Products name: "EB-L1490U Projectors, Installation/Large venue, WUXGA, 1920 x 1200, 16:10, 4K enhancement, 9.000�lumen- 6.300�lumen�(economy) In accordance with IDMS15.4, 9.000 lumen - 6.300�lumen�(economy) In accordance with ISO 21118:2012, 2.500.000�: 1, Stereo mini jack audio in (3x), Stereo mini jack audio out, HDBaseT, BNC in, HDMI in, DVI in, VGA out, VGA in, Ethernet interface (100 Base-TX / 10 Base-T), RS-232C, USB 2.0 Type B (Service Only), HD-SDI, Wireless LAN b/g/n (2.4GHz) (optional), 23,8�kg, CD Manual, Cable cover, VGA cable, Power and signal cable (3 m), Quick Start Guide, Remote control incl. batteries" exceeds max. length: 64
UPDATED! - Model: V11HA16040 P390 | 1 | | EB-L1490U | EB-L1490U | | | | | 207058.732 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H981040 P390 - Products name: "EB-E20, Projectors, Mobile, XGA, 1024 x 768, 4:3, HD ready, 3.400�Lumen- 2.200�Lumen�(economy), 3.400�Lumen - 2.200�Lumen�(economy) In accordance with ISO 21118:2013, 15.000�: 1, USB 2.0 Type A, RS-232C, VGA in (2x), VGA out, HDMI in, Composite in, Stereo mini jack audio out, Stereo mini jack audio in (2x), Cinch audio in, USB 2.0 Type B, 3,1�kg, 5�Watt, Computer cable, Main unit, Power cable" exceeds max. length: 64
UPDATED! - Model: V11H981040 P390 | 1 | | EB-E20, Pr | EB-E20, Pr | | | | | 8849.36 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H988040 P390 - Products name: "EB-992F, Projectors, Mobile/Large venue, Full HD 1080p, 1920 x 1080, 16:9, Full HD, 4.000�Lumen- 2.400�Lumen�(economy), 4.000�Lumen - 2.400�Lumen�(economy) In accordance with ISO 21118:2013, 16.000�: 1, USB 2.0 Type A, USB 2.0 Type B, RS-232C, Ethernet interface (100 Base-TX / 10 Base-T), VGA in (2x), VGA out, HDMI in (2x), Composite in, Stereo mini jack audio out, Stereo mini jack audio in (2x), Cinch audio out, Microphone input, Wireless LAN IEEE 802.11b/g/n, Miracast, 3,1�kg, 16�Watt, Computer cable, Main unit, Power cable, Remote control incl. batteries, User manual, Warranty document, Wireless LAN unit" exceeds max. length: 64
UPDATED! - Model: V11H988040 P390 | 1 | | EB-992F, P | EB-992F, P | | | | | 19303.746 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H978040 P390 - Products name: "EB-FH52, Projectors, Mobile, Full HD 1080p, 1920 x 1080, 16:9, Full HD, 4.000�Lumen- 2.400�Lumen�(economy) In accordance with ISO 21118:2013, 4.000�Lumen - 2.400�Lumen�(economy) In accordance with ISO 21118:2013, 16.000�: 1, USB 2.0 Type A, USB 2.0 Type B, Wireless LAN IEEE 802.11b/g/n, VGA in, HDMI in (2x), Composite in, Cinch audio in, Miracast, 3,1�kg, 16�Watt, Carrying Case, Computer cable, Main unit, Power cable, Remote control incl. batteries, User's Manual Set, Warranty Documents" exceeds max. length: 64
UPDATED! - Model: V11H978040 P390 | 1 | | EB-FH52, P | EB-FH52, P | | | | | 15518.244 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H983040 P390 - Products name: "EB-W49, Projectors, Mobile, WXGA, 1280 x 800, 16:10, 3.800�Lumen, 3.800�Lumen In accordance with ISO 21118:2013, 16.000�: 1, USB 2.0 Type A, USB 2.0 Type B, RS-232C, Ethernet interface (100 Base-TX / 10 Base-T), Wireless LAN a/n (5GHz) (optional), VGA in (2x), VGA out, HDMI in (2x), Composite in, Stereo mini jack audio out, Stereo mini jack audio in (2x), Cinch audio in, 2,7�kg, 5�Watt, Computer cable, Power cable, Quick Setup Guide, Remote control incl. batteries, Warranty card" exceeds max. length: 64
UPDATED! - Model: V11H983040 P390 | 1 | | EB-W49, Pr | EB-W49, Pr | | | | | 13000.764 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H914040 P390 - Products name: "EF-100W Portable laser projector, white. HD ready, 0.59 inch LCD panel, Contrast: 2.500.000:1 Aspect ratio 16:10, Laser light source, Screen size 30-150 inches, USB 2.0 Type A, USB 2.0 Type B, HDMI in, Stereo mini jack audio out, Bluetooth, Power consumption: 172 Watt, 115 Watt (economy), 0,4 Watt (standby), Heat dissipation: 584,8 BTU/hour (max), Dimensions 210x230x92mm, Weight 2.7kg Room Type / Application: Gaming, Home Cinema, Home Office, Home Photo, Huddle space / Portable, Sports, Streaming, TV & Box sets." exceeds max. length: 64
UPDATED! - Model: V11H914040 P390 | 1 | | EF-100W Po | EF-100W Po | | | | | 10918.404 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: V11H914040 P390 - Products name: "EF-100W Portable laser projector, white. HD ready, 0.59 inch LCD panel, Contrast: 2.500.000:1 Aspect ratio 16:10, Laser light source, Screen size 30-150 inches, USB 2.0 Type A, USB 2.0 Type B, HDMI in, Stereo mini jack audio out, Bluetooth, Power consumption: 172 Watt, 115 Watt (economy), 0,4 Watt (standby), Heat dissipation: 584,8 BTU/hour (max), Dimensions 210x230x92mm, Weight 2.7kg Room Type / Application: Gaming, Home Cinema, Home Office, Home Photo, Huddle space / Portable, Sports, Streaming, TV & Box sets." exceeds max. length: 64
UPDATED! - Model: V11H914040 P390 | 1 | | EF-100W Po | EF-100W Po | | | | | 10918.404 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Projectors | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: C11CG07402SA P390 - Products name: "Epson WorkForce Pro WF-M5299DW, WorkForce Pro. Maximum duty cycle: 45000 pages per month, Maximum resolution: 1200 x 1200 DPI, Standard printer languages: ESC/P-R,PCL 5e,PCL 6,PDF 1.7,PostScript 3. Print speed (black, normal quality, A4/US Letter): 34 ppm, Time to first page (black, normal): 4.8 s, Duplex print speed (ISO/IEC 24734, A4) black: 15 ppm. Standard input capacity: 250 sheets, Maximum input capacity: 251 sheets. Standard output capacity: 150 sheets. Maximum ISO A-series paper size: A4, Standard tray media types: Letterhead,Plain paper,Postcard,Recycled paper, ISO A-series sizes (A0...A9): A4,A5,A6 12�months�Carry in" exceeds max. length: 64
UPDATED! - Model: C11CG07402SA P390 | 1 | | Epson Work | Epson Work | | | | | 5266.107 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Printers a | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
WARNING! - Model: C11CH72403SA P390 - Products name: "Epson L15150 MEAF, Inkjet Printers, Consumer/Multi-fuction/Ink tank system, A3+, 4 Ink Cartridges, CMKY, Print, Scan, Copy, Fax, Yes (A4/A3, plain paper), Touchscreen, 4.800�x�2.400�dpi, 22�pages/min�Colour (plain paper), 32�pages/min�Monochrome (plain paper), 250�Sheets�Standard, 2.400�dpi x 1.200�dpi (Horizontal x Vertical), 50�pages, LCD screen: Type: Colour, Touchscreen, Diagonal:�10,9�cm, WiFi, Ethernet, USB, USB host, Wi-Fi Direct, Mac OS X 10.6.8 or later, Windows 10 (32/64 bit), Windows 7 (32/64 bit), Windows 8 (32/64 bit), Windows 8.1 (32/64 bit), Windows Server 2008 R2, Windows Server 2012 R2, Windows Server 2016, Windows Vista (32/64 bit), Windows XP Professional x64 Edition SP2 or later, Windows XP SP3 or later (32-bit), Windows Server 2003 R2, Windows Server 2003 SP2 or later, 1 set of ink (1x 127ml BK, 3x 70ml CMY), Main unit, Power cable, Quick Start Guide, User manual, 12�months�Carry in, 150.000�pages" exceeds max. length: 64
UPDATED! - Model: C11CH72403SA P390 | 1 | | Epson L151 | Epson L151 | | | | | 15736.446 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | | | 0 | Epson | Printers a | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |

Finished Processing Import File