Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18
  1. #11
    Join Date
    Sep 2006
    Posts
    542
    Plugin Contributions
    0

    Default Re: Strange characters in product description, can you help?

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

    Play with it long enough and you will break it.

  2. #12
    Join Date
    Jun 2008
    Posts
    24
    Plugin Contributions
    0

    Default Re: Strange characters in product description, can you help?

    Quote Originally Posted by usernamenone View Post
    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
    ANY ONE KNOW WHAT TO DO???
    Ambra
    ---------------------------------

  3. #13
    Join Date
    Feb 2010
    Location
    Syracuse, NY
    Posts
    2,159
    Plugin Contributions
    17

    Default Re: Strange characters in product description, can you help?

    just a suggestion but check you db collation

  4. #14
    Join Date
    Jun 2008
    Posts
    24
    Plugin Contributions
    0

    Default Re: Strange characters in product description, can you help?

    Quote Originally Posted by rbarbour View Post
    just a suggestion but check you db collation
    what you mean by that?
    Ambra
    ---------------------------------

  5. #15
    Join Date
    Jun 2008
    Posts
    24
    Plugin Contributions
    0

    Default Re: Strange characters in product description, can you help?

    Quote Originally Posted by rbarbour View Post
    just a suggestion but check you db collation
    YES you are right all DB collation is in latin2_general_ci
    what to do now?
    Ambra
    ---------------------------------

  6. #16
    Join Date
    Feb 2010
    Location
    Syracuse, NY
    Posts
    2,159
    Plugin Contributions
    17

    Default Re: Strange characters in product description, can you help?

    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.

  7. #17
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Strange characters in product description, can you help?

    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.


    Quote Originally Posted by rbarbour View Post
    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.
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  8. #18
    Join Date
    Mar 2020
    Location
    Cape Town
    Posts
    42
    Plugin Contributions
    0

    Default Re: Strange characters in product description, can you help?

    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

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v150 Strange characters appearing in product name/descriptions
    By kman55 in forum General Questions
    Replies: 2
    Last Post: 11 Jun 2012, 09:33 PM
  2. Displaying Japanese Characters in Product Description
    By flipperjoint in forum General Questions
    Replies: 0
    Last Post: 14 Jan 2012, 08:24 AM
  3. Changing the product description lengh from 15 characters?
    By dan_ballan in forum Templates, Stylesheets, Page Layout
    Replies: 13
    Last Post: 15 Jul 2007, 10:13 PM
  4. Can you use wildcard characters when creating coupon codes?
    By aaelghat in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 1
    Last Post: 2 Jul 2007, 05:17 AM
  5. Strange Characters in Product Description
    By howser in forum General Questions
    Replies: 1
    Last Post: 21 Jun 2006, 05:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR