Skip navigation links

MySQL Forums :: PHP :: Newby needs some help - collation/charset ?


Advanced Search

Newby needs some help - collation/charset ?
Posted by: Marvin Miller ()
Date: December 14, 2013 01:08PM

Hi Folks!

I really need some help with an issue that seems to be related to collation or charset or perhaps the fact that I'm using a too new version of MySQL for the code?

This is a PHP website (forum) with MySQL on a separate machine. Versions are PHP 5.4.14 MySQL 5.6.13 It used to work with an older PHP and an older MySQL version.

Symptoms are that some PHP scripts being run against the dB fail. In particular, two come to mind. One, an insert statement that inserts a bunch of German into the table (causing me to wonder about strange characters) and the second is that a user reported that he uses Word for Windows to create his posts before copying & pasting them into the forum. Whenever he does this, and the post contains comma's, exclamation marks etc - the post fails.

The table collation settings in MySQL for the failed queries is utf8_general_ci

Can anyone point me the right direction? I can include a MySQL script that fails each time. When the issue occurs you get the regular square box in your browser window stating that there is a dB error but there is never any content in that box - it's empty.

This is becoming really troublesome - any advice or pointers would be appreciated.

Options: ReplyQuote


Subject Written By Posted
Newby needs some help - collation/charset ? Marvin Miller 12/14/2013 01:08PM
Re: Newby needs some help - collation/charset ? Barry Galbraith 12/15/2013 04:19AM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/16/2013 05:25PM
Re: Newby needs some help - collation/charset ? Barry Galbraith 12/16/2013 07:35PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/16/2013 08:48PM
Re: Newby needs some help - collation/charset ? Barry Galbraith 12/16/2013 10:07PM
Re: Newby needs some help - collation/charset ? Rick James 12/17/2013 05:19PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/18/2013 01:02AM
Re: Newby needs some help - collation/charset ? Rick James 12/18/2013 01:36PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/18/2013 03:34PM
Re: Newby needs some help - collation/charset ? Rick James 12/18/2013 05:10PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/18/2013 05:37PM
Re: Newby needs some help - collation/charset ? Rick James 12/18/2013 06:28PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/20/2013 01:09PM
Re: Newby needs some help - collation/charset ? Rick James 12/20/2013 03:24PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/20/2013 03:37PM
Re: Newby needs some help - collation/charset ? Rick James 12/20/2013 06:59PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/20/2013 09:20PM
Re: Newby needs some help - collation/charset ? Rick James 12/21/2013 12:55AM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/21/2013 01:31AM
Re: Newby needs some help - collation/charset ? Rick James 12/21/2013 02:12AM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/21/2013 02:49AM
Re: Newby needs some help - collation/charset ? Rick James 12/21/2013 01:11PM
Re: Newby needs some help - collation/charset ? Marvin Miller 12/22/2013 04:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.