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,', LEN
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 wrote:
> information_schema.columns reports a character_set_name of 'utf8' and a
> collation_name of 'utf8_general_ci'
>
> O
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
wrote:
>
> Is this a bug? If it's a "feature", what could we do instead to get
>> around
>> this issue?
>>
>
> Is your column set
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
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),
LENGTH('031492349
