Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20
  1. #11
    Join Date
    Jan 2019
    Location
    New Zealand
    Posts
    38
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    Look for "twin"

  2. #12
    Join Date
    Jan 2015
    Posts
    423
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    okay well if i remove the (') (-)etc.... it seems to work. The question now is why does it not accept those characters anymore?

  3. #13
    Join Date
    Jan 2019
    Location
    New Zealand
    Posts
    38
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    The dashes and apostrophes were misinterpreted in the ASCII code as latin1. Did you cut and paste from a different document, such as Word or a PDF?

  4. #14
    Join Date
    Jan 2015
    Posts
    423
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    i took it write from notepad. Could it be a setting on the server causing that issue?

  5. #15
    Join Date
    Jan 2019
    Location
    New Zealand
    Posts
    38
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    I have never been able to get “” in notepad. I only get "". That “” is not utf8 and will get sanitized

  6. #16
    Join Date
    Jan 2015
    Posts
    423
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    I am sorry I meant dreamweaver. But even with that same copy it works on my local machine thats what makes me think it could be a server setting.

  7. #17
    Join Date
    Jan 2015
    Posts
    423
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    okay so obviously it was the text in the description. I fixed the characterisitcs that were not behaving. Something so easy could be so frustrating at times

  8. #18
    Join Date
    Jan 2019
    Location
    New Zealand
    Posts
    38
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    PHP7 is stricter on what it allows. Simply “” is used by other programs to make a quotation mark look pretty. A server talks in code, not pretty code. A quotation mark is "" to a server, nothing else.

  9. #19
    Join Date
    Jan 2019
    Location
    New Zealand
    Posts
    38
    Plugin Contributions
    0

    Default Re: MySQLi error 1366: Incorrect string value

    Yes I have been caught out myself. Took a while to learn what Zen Cart accepts or sanitizes, or even half sanitizes. Writing in notepad stops most mistakes from happening and be careful about cut and pastes from other sources, you never know what special characters have been hidden in that text

  10. #20
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,108
    Plugin Contributions
    11

    Default Re: MySQLi error 1366: Incorrect string value

    As others have in the past, you'll find that Dreamweaver talks a different language in it's creating content.

    Unless you are better than most of us at controlling this, Dreamweaver is NOT recommended for any use with Zen Cart.

    For those of you who want to see the worst in hidden code; open Word, type in "Hello World" without the quotes, save it as hello.html and open it with notepad. No better example of how the wrong text generator can really mess up your day.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 7
    Last Post: 22 Dec 2019, 07:07 PM
  2. Replies: 10
    Last Post: 29 Nov 2010, 06:31 AM
  3. "1366 Incorrect string value" during installation
    By abo_shreek11 in forum Installing on a Windows Server
    Replies: 2
    Last Post: 24 Apr 2010, 07:04 AM
  4. 1366 Incorrect string value: 'zone_name'
    By technologist in forum Installing on a Windows Server
    Replies: 2
    Last Post: 9 Jul 2008, 04:17 PM
  5. VAT error message (1366 Incorrect decimal value)
    By Typhoon in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 5
    Last Post: 18 Jul 2006, 11:32 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