MySQL Forums
Forum List  »  Newbie

Re: Coding UTF-8 / Czech
Posted by: Peter Brawley
Date: August 22, 2016 03:02PM

Why's this like pulling teeth?

You are quoting a result in the mysql client programme? If not, what is the result when you show the input string in the mysql client programme, and when you show the table content, in the mysql client, after inserting them?

The table's `name` and `value` columns are utf8 / utf8_czech_ci. Have you proved that the input you are using actually matches that, eg by showing that with matching client settings, you can display the input string correctly?

Your client setting is utf8mb4. When that is changed to match the table, do your results change?

... And so on for each logically possible mismatch, the point being that you need to check every possible mismatch till you find the mismatch(es) without which the result is correct.

Options: ReplyQuote


Subject
Written By
Posted
August 16, 2016 03:05AM
August 16, 2016 10:19AM
August 16, 2016 10:36AM
August 16, 2016 02:42PM
August 17, 2016 01:48AM
August 18, 2016 06:40PM
August 18, 2016 08:16PM
August 19, 2016 10:11AM
August 19, 2016 02:43PM
August 22, 2016 03:29AM
August 22, 2016 10:18AM
August 22, 2016 01:49PM
Re: Coding UTF-8 / Czech
August 22, 2016 03:02PM
August 22, 2016 03:32PM


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.