information_schema.columns reports a character_set_name of 'utf8' and a
collation_name of 'utf8_general_ci'
On Wed, Jun 3, 2015 at 3:14 PM, Emil Oppeln-Bronikowski e...@fuse.pl
wrote:
Is this a bug? If it's a feature, what could we do instead to get
around
this issue?
Is your column set
We're finding that, when working with the em dash character, the LEFT and
LENGTH functions don't work well together. This query shows trying to
strip off the last character from a string containing an em dash:
mysql select LEFT('031492349−0002,', LENGTH('031492349−0002,') - 1),
Is this a bug? If it's a feature, what could we do instead to get around
this issue?
Is your column set to unicode?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 2015-06-03 2:55 PM, Robert Voliva wrote:
We're finding that, when working with the em dash character, the LEFT and
LENGTH functions don't work well together. This query shows trying to
strip off the last character from a string containing an em dash:
mysql select LEFT('031492349−0002,',
LENGTH() measures bytes, CHAR_LENGTH() measures characters. There's
little use for LENGTH() for anything else then raw bytes.
On Wed, Jun 3, 2015 at 10:29 PM, Robert Voliva rvol...@gmail.com wrote:
information_schema.columns reports a character_set_name of 'utf8' and a
collation_name of