|
Sticky:
MySQL 8.0: Improved UTF8, Unicode, Collations (1 Posts)
|
129 |
Edwin Desouza
|
01/13/2017 09:48AM
|
|
Sticky:
InnoDB Full Text: CJK, ngram, mecab (1 Posts)
|
1,291 |
Edwin Desouza
|
03/17/2015 09:47AM
|
|
Sticky:
MySQL Character Sets, UTF8, Unicode: Articles, Blogs, Docs (1 Posts)
|
10,160 |
Edwin DeSouza
|
11/12/2008 12:23PM
|
|
MySQL 8.0: New collations UTF-8
|
20 |
Edwin Desouza
|
03/16/2017 01:04PM
|
|
MySQL 8.0: UTF8, Collations, Unicode
|
85 |
Edwin Desouza
|
02/06/2017 01:38PM
|
|
MySLQ 8.0: Sushi = Beer ?! An introduction of UTF8 support
|
75 |
Edwin Desouza
|
02/06/2017 01:37PM
|
|
No ascii characters from java
|
132 |
michael Mauro
|
01/16/2017 05:39AM
|
|
Re: No ascii characters from java
|
69 |
Peter Brawley
|
01/16/2017 09:30AM
|
|
Re: No ascii characters from java
|
64 |
michael Mauro
|
01/19/2017 07:41AM
|
|
4 byte emoji chars displayed as ?? when Japanese characters included
|
235 |
Stuart McClune
|
01/08/2017 03:00PM
|
|
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
|
94 |
Peter Brawley
|
01/08/2017 04:19PM
|
|
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
|
97 |
Stuart McClune
|
01/08/2017 04:49PM
|
|
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
|
90 |
Stuart McClune
|
01/08/2017 05:31PM
|
|
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
|
83 |
Peter Brawley
|
01/08/2017 08:12PM
|
|
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
|
119 |
Xing Zhang
|
01/09/2017 08:06PM
|
|
MySQL utf-8 issue with json
|
406 |
Mehmet Akif Kardas
|
10/25/2016 07:00AM
|
|
Re: MySQL utf-8 issue with json
|
177 |
Rick James
|
10/26/2016 08:20PM
|
|
Re: MySQL utf-8 issue with json
|
152 |
Mehmet Akif Kardas
|
10/27/2016 09:02AM
|
|
How to get SELECT COERCIBILITY(xxx)=1?
|
451 |
Huanting Liu
|
09/06/2016 10:07PM
|
|
HUANTING LIU - more about collations
|
509 |
Rick James
|
08/14/2016 06:30PM
|
|
Re: HUANTING LIU - more about collations
|
239 |
huanting liu
|
08/15/2016 10:21AM
|
|
Error Code 1300: Invalid utf8 character string
|
6,138 |
Michaela Metzger
|
08/09/2016 01:40PM
|
|
Re: Error Code 1300: Invalid utf8 character string
|
2,651 |
Peter Brawley
|
08/09/2016 02:41PM
|
|
Re: Error Code 1300: Invalid utf8 character string
|
3,776 |
Michaela Metzger
|
08/09/2016 03:35PM
|
|
Re: Error Code 1300: Invalid utf8 character string
|
2,955 |
Rick James
|
08/14/2016 06:33PM
|
|
Where can I find information about utf8mb4_general_ci?
|
438 |
HUANTING LIU
|
08/04/2016 08:56PM
|
|
How to insert 4bit character in mysql table?
|
506 |
Rama krishnan
|
08/01/2016 11:49PM
|
|
Re: How to insert 4byte character in mysql table?
|
231 |
Rick James
|
08/03/2016 02:59PM
|
|
Trying NOT to remove accentation
|
536 |
Milos Losmi
|
06/10/2016 07:38AM
|
|
Re: Trying NOT to remove accentation
|
265 |
Peter Brawley
|
06/10/2016 08:55AM
|
|
Re: Trying NOT to remove accentation
|
254 |
Jeremy Smyth
|
06/10/2016 10:12AM
|
|
Re: Trying NOT to remove accentation
|
255 |
Rick James
|
06/13/2016 02:01AM
|
|
Re: Trying NOT to remove accentation
|
252 |
Milos Losmi
|
06/16/2016 01:15AM
|
|
Data Migration from 5.6.29 to 5.7.12
|
852 |
Maurizio Scarano
|
06/02/2016 06:40AM
|
|
Re: Data Migration from 5.6.29 to 5.7.12
|
281 |
Peter Brawley
|
06/10/2016 09:02AM
|
|
Re: Data Migration from 5.6.29 to 5.7.12
|
268 |
Rick James
|
06/13/2016 11:00AM
|
|
Greek.xml on charsets
|
589 |
Δημήτριος Θεοδωρόπουλος
|
04/20/2016 09:32AM
|
|
Re: Greek.xml on charsets
|
300 |
Rick James
|
04/22/2016 06:22PM
|
|
How to get rid of VT FF etc. special chars
|
634 |
Thomas H.
|
03/30/2016 01:16AM
|
|
Re: How to get rid of VT FF etc. special chars
|
405 |
Rick James
|
03/31/2016 09:30AM
|
|
Characters not accepted
|
880 |
Ole Roger Dahle
|
03/13/2016 09:01AM
|
|
Re: Characters not accepted
|
308 |
Rick James
|
03/15/2016 08:29PM
|
|
Re: Characters not accepted
|
310 |
Peter Brawley
|
03/30/2016 09:13AM
|
|
Byte level storage seems right, display seems wrong
|
745 |
Andy Theuninck
|
02/25/2016 11:35AM
|
|
Re: Byte level storage seems right, display seems wrong
|
370 |
Rick James
|
02/26/2016 01:36PM
|
|
Re: Byte level storage seems right, display seems wrong
|
316 |
Andy Theuninck
|
02/26/2016 02:56PM
|
|
Re: Byte level storage seems right, display seems wrong
|
356 |
Rick James
|
03/05/2016 01:10AM
|
|
An UTF8 oddity
|
685 |
Chris Devine
|
02/23/2016 11:00AM
|
|
Re: An UTF8 oddity
|
340 |
Chris Devine
|
02/23/2016 12:45PM
|
|
Re: An UTF8 oddity
|
321 |
Rick James
|
02/26/2016 09:11PM
|
|
Store mathematical equations in MySql DB
|
1,709 |
Karthik Babu
|
02/09/2016 12:59AM
|
|
Re: Store mathematical equations in MySql DB
|
707 |
Jon Stephens
|
02/09/2016 03:43AM
|
|
Re: Store mathematical equations in MySql DB
|
504 |
Rick James
|
02/16/2016 10:51PM
|
|
can't insert that character 💀
|
742 |
Ersin KARAKADIOĞLU
|
02/02/2016 08:42AM
|
|
Re: can't insert that character 💀
|
417 |
Peter Brawley
|
02/02/2016 04:50PM
|
|
Re: can't insert that character 💀
|
316 |
batuhan arol
|
02/16/2016 05:59AM
|
|
Re: can't insert that character 💀
|
335 |
Ersin KARAKADIOĞLU
|
02/03/2016 12:12AM
|
|
Database names created with 4-byte characters displayed as ???
|
791 |
Jennifer Roos
|
12/10/2015 12:50PM
|
|
Re: Database names created with 4-byte characters displayed as ???
|
418 |
Rick James
|
12/15/2015 11:13AM
|
|
ORDER BY - why doesnt it work??
|
876 |
Simon Gabor
|
11/19/2015 06:59AM
|
|
Re: ORDER BY - why doesnt it work??
|
424 |
Jeremy Smyth
|
11/19/2015 07:22AM
|
|
Re: ORDER BY - why doesnt it work??
|
426 |
Simon Gabor
|
11/19/2015 07:27AM
|
|
Can someone help me explain what is going on
|
802 |
mawie asdfasdf
|
10/20/2015 04:10AM
|
|
Re: Can someone help me explain what is going on
|
429 |
Rick James
|
10/24/2015 10:59PM
|
|
load data infile ... with UTF-8 characters
|
1,506 |
Bruce Malmat
|
09/05/2015 05:42PM
|
|
Re: load data infile ... with UTF-8 characters
|
538 |
Xing Zhang
|
09/13/2015 08:18PM
|
|
Re: load data infile ... with UTF-8 characters
|
610 |
Bruce Malmat
|
09/14/2015 02:05PM
|
|
Re: load data infile ... with UTF-8 characters
|
519 |
Rick James
|
09/16/2015 01:16PM
|
|
Re: load data infile ... with UTF-8 characters
|
652 |
Bruce Malmat
|
09/16/2015 04:01PM
|
|
Re: load data infile ... with UTF-8 characters
|
530 |
Bruce Malmat
|
09/17/2015 01:21PM
|
|
Re: load data infile ... with UTF-8 characters
|
566 |
Rick James
|
09/18/2015 09:24PM
|
|
Re: load data infile ... with UTF-8 characters
|
556 |
Bruce Malmat
|
09/23/2015 11:49AM
|
|
Re: load data infile ... with UTF-8 characters
|
482 |
Xing Zhang
|
09/29/2015 01:12AM
|
|
Re: load data infile ... with UTF-8 characters
|
550 |
Rick James
|
10/02/2015 03:51PM
|
|
Re: load data infile ... with UTF-8 characters
|
457 |
Bruce Malmat
|
10/02/2015 05:28PM
|
|
Re: load data infile ... with UTF-8 characters
|
483 |
Rick James
|
10/02/2015 09:17PM
|
|
Re: load data infile ... with UTF-8 characters
|
513 |
Bruce Malmat
|
10/02/2015 09:54PM
|
|
MySQL returns the same result using the IN clause irrespective of the value used
|
1,105 |
Deepthi Pullannagari
|
07/15/2015 11:07AM
|
|
Re: MySQL returns the same result using the IN clause irrespective of the value used
|
582 |
Peter Brawley
|
07/15/2015 01:55PM
|
|
Re: MySQL returns the same result using the IN clause irrespective of the value used
|
527 |
Rick James
|
07/17/2015 03:49PM
|
|
Can't insert the '&' character ...
|
1,079 |
Anders Gunnare
|
07/10/2015 03:01AM
|
|
Re: Can't insert the '&' character ...
|
573 |
Rick James
|
07/11/2015 02:27PM
|
|
[For Polish mysql programmers mainly] Retrieving character ł in query
|
1,264 |
Mikey Terracano
|
05/14/2015 12:34AM
|
|
Re: [For Polish mysql programmers mainly] Retrieving character ł in query
|
617 |
Rick James
|
05/17/2015 11:25AM
|
|
1273 - Unknown collation: 'utf8mb4_unicode_ci' error
|
14,587 |
Paolo Bergomi
|
05/04/2015 10:30AM
|
|
Re: 1273 - Unknown collation: 'utf8mb4_unicode_ci' error
|
4,154 |
Paolo Bergomi
|
05/05/2015 08:48AM
|
|
Like operator and cyrillic symbols with MySQL and jdbc
|
1,659 |
Arthur Harkivskyi
|
03/29/2015 08:12AM
|
|
Re: Like operator and cyrillic symbols with MySQL and jdbc
|
966 |
Arthur Harkivskyi
|
03/29/2015 08:17AM
|
|
Re: Like operator and cyrillic symbols with MySQL and jdbc
|
948 |
Rick James
|
04/01/2015 03:37PM
|
|
Re: Like operator and cyrillic symbols with MySQL and jdbc
|
580 |
Rick James
|
04/01/2015 03:39PM
|
|
hostname not set correctly on MySQL 5.6 on Korean Windows
|
1,463 |
Jennifer Roos
|
03/04/2015 02:47PM
|
|
Re: hostname not set correctly on MySQL 5.6 on Korean Windows
|
711 |
Rick James
|
03/06/2015 09:57AM
|
|
Re: hostname not set correctly on MySQL 5.6 on Korean Windows
|
660 |
Jennifer Roos
|
03/06/2015 04:06PM
|
|
Re: hostname not set correctly on MySQL 5.6 on Korean Windows
|
676 |
Rick James
|
03/08/2015 12:06AM
|
|
Re: hostname not set correctly on MySQL 5.6 on Korean Windows
|
641 |
Jennifer Roos
|
03/09/2015 08:57AM
|
|
Re: hostname not set correctly on MySQL 5.6 on Korean Windows
|
751 |
Rick James
|
03/12/2015 04:49PM
|
|
Re: hostname not set correctly on MySQL 5.6 on Korean Windows
|
681 |
Jennifer Roos
|
03/13/2015 12:58PM
|
|
Re: hostname not set correctly on MySQL 5.6 on Korean Windows
|
635 |
Rick James
|
03/14/2015 10:29AM
|
|
What will be the best Data-type to store md5\sha1 hashes in MySQL?
|
2,141 |
sandeep thakur
|
02/04/2015 06:24AM
|
|
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
|
1,027 |
Rick James
|
02/05/2015 06:57PM
|
|
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
|
826 |
sandeep thakur
|
02/11/2015 01:33AM
|
|
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
|
760 |
Rick James
|
02/12/2015 12:13AM
|
|
Collation Weirdness with UNION in VIEW
|
1,787 |
Andy Theuninck
|
11/25/2014 11:16AM
|
|
Re: Collation Weirdness with UNION in VIEW
|
785 |
Rick James
|
11/26/2014 10:56AM
|
|
Replace command & backslash
|
1,580 |
Mauro Miotello
|
11/16/2014 03:03AM
|
|
Re: Replace command & backslash
|
716 |
Rick James
|
11/17/2014 12:10AM
|
|
Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
|
9,946 |
Muhammad Ali
|
10/04/2014 03:11AM
|
|
Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
|
2,797 |
Muhammad Ali
|
10/04/2014 04:37AM
|
|
Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
|
2,187 |
Muhammad Ali
|
10/06/2014 05:00AM
|
|
Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
|
2,660 |
Rick James
|
10/07/2014 04:20PM
|
|
Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
|
2,402 |
Muhammad Ali
|
10/10/2014 07:50AM
|
|
Numeric equivalents of characters
|
1,631 |
Monica Braverman
|
09/29/2014 05:09PM
|
|
Re: Numeric equivalents of characters
|
777 |
Rick James
|
10/01/2014 12:24AM
|
|
Re: Numeric equivalents of characters
|
812 |
Rick James
|
10/01/2014 11:16PM
|
|
Can someone please explain this misbehavior?
|
1,780 |
A B
|
08/19/2014 07:53PM
|
|
Re: Can someone please explain this misbehavior?
|
859 |
Rick James
|
08/20/2014 07:23PM
|
|
Re: Can someone please explain this misbehavior?
|
880 |
A B
|
08/20/2014 08:15PM
|
|
Re: Can someone please explain this misbehavior?
|
1,030 |
Rick James
|
08/21/2014 05:25PM
|
|
Why is latin1 used?
|
1,723 |
Fabian Uhlenbrock
|
08/21/2014 03:38AM
|
|
Re: Why is latin1 used?
|
837 |
A B
|
08/21/2014 08:17AM
|
|
Re: Why is latin1 used?
|
830 |
Rick James
|
08/21/2014 12:18PM
|
|
incorrect string error when i run mysql for a particular column please help me
|
1,619 |
Usman Baig
|
08/18/2014 04:31AM
|
|
Re: incorrect string error when i run mysql for a particular column please help me
|
780 |
Rick James
|
08/19/2014 06:00PM
|
|
Italian locale on format()
|
1,758 |
Mario Bianchi Bianchi
|
07/23/2014 01:25AM
|
|
Re: Italian locale on format()
|
821 |
Rick James
|
07/24/2014 05:23PM
|
|
Insert Chinese Special Character gibberish ???
|
2,076 |
jianjun yang
|
07/08/2014 08:09PM
|
|
Re: Insert Chinese Special Character gibberish ???
|
1,079 |
Rick James
|
07/10/2014 08:11AM
|
|
Re: Insert Chinese Special Character gibberish ???
|
974 |
jianjun yang
|
07/15/2014 03:11AM
|
|
LOWER() influences utf8_bin collation?
|
2,234 |
Wojciech Scigala
|
04/19/2014 04:03AM
|
|
Re: LOWER() influences utf8_bin collation?
|
1,098 |
Rick James
|
04/21/2014 11:43PM
|
|
Re: LOWER() influences utf8_bin collation?
|
1,014 |
Wojciech Scigala
|
04/22/2014 03:25PM
|
|
Re: LOWER() influences utf8_bin collation?
|
981 |
Rick James
|
04/23/2014 11:13AM
|
|
Clean up Character Set mess in the same field of one table
|
1,955 |
Tobias Keller
|
04/07/2014 09:42AM
|
|
Re: Clean up Character Set mess in the same field of one table
|
1,056 |
Rick James
|
04/08/2014 11:48AM
|
|
UTF8, latin1 and performance impact
|
4,308 |
Christophe Schermesser
|
03/10/2014 04:55AM
|
|
Re: UTF8, latin1 and performance impact
|
2,268 |
Rick James
|
03/11/2014 07:53AM
|
|
solution for insert certain utf-8 data into Mysql
|
2,037 |
gaurav jain
|
10/19/2013 02:20AM
|
|
Re: solution for insert certain utf-8 data into Mysql
|
1,140 |
Rick James
|
10/20/2013 11:15AM
|
|
Can't identify character set and collation used in string comparisons
|
2,754 |
David Raimosson
|
07/13/2013 03:03PM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,239 |
Rick James
|
07/21/2013 12:29PM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,317 |
David Raimosson
|
07/22/2013 04:08AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,342 |
Peter Brawley
|
07/22/2013 04:18PM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,283 |
Rick James
|
07/22/2013 08:45PM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,395 |
David Raimosson
|
07/23/2013 02:33AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,318 |
Rick James
|
07/23/2013 09:15AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,421 |
David Raimosson
|
07/24/2013 02:24AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,187 |
Rick James
|
07/24/2013 09:31AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,249 |
David Raimosson
|
07/25/2013 08:10AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,298 |
Rick James
|
07/25/2013 09:25AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,439 |
David Raimosson
|
08/05/2013 12:29AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,239 |
David Raimosson
|
07/23/2013 02:00AM
|
|
Re: Can't identify character set and collation used in string comparisons
|
1,201 |
gaurav jain
|
10/19/2013 02:29AM
|
|
data type and Character set for DUTCH language
|
2,502 |
Syed Zaeem Abbas
|
07/23/2013 05:57AM
|
|
Re: data type and Character set for DUTCH language
|
1,383 |
Rick James
|
07/24/2013 08:57AM
|
|
Re: data type and Character set for DUTCH language
|
1,248 |
Syed Zaeem Abbas
|
07/27/2013 02:19AM
|
|
Re: data type and Character set for DUTCH language
|
1,640 |
Rick James
|
07/28/2013 03:23PM
|
|
utf8 column is storing only half of the maximum number of characters
|
2,330 |
Michael Rivard
|
06/17/2013 08:11PM
|
|
Re: utf8 column is storing only half of the maximum number of characters
|
1,205 |
Rick James
|
06/17/2013 10:40PM
|
|
mysql can not to insert unicode16 uncommon word
|
2,751 |
mzy ma
|
05/13/2013 02:27AM
|
|
Re: mysql can not to insert unicode16 uncommon word
|
1,298 |
Rick James
|
05/13/2013 09:16PM
|
|
Re: mysql can not to insert unicode16 uncommon word
|
1,205 |
mzy ma
|
05/14/2013 09:07PM
|
|
Re: mysql can not to insert unicode16 uncommon word
|
1,229 |
Rick James
|
05/15/2013 08:03PM
|
|
Re: mysql can not to insert unicode16 uncommon word
|
1,248 |
mzy ma
|
05/16/2013 01:48AM
|
|
Re: mysql can not to insert unicode16 uncommon word
|
1,441 |
Rick James
|
05/16/2013 09:02PM
|
|
mysql_query and embarcadero c++
|
3,651 |
tawab zawiti
|
04/05/2013 06:30AM
|
|
Re: mysql_query and embarcadero c++
|
1,356 |
Rick James
|
04/06/2013 11:53AM
|
|
Characters not getting stored
|
3,194 |
Andrea Croci
|
04/02/2013 01:19PM
|
|
Re: Characters not getting stored
|
1,330 |
Rick James
|
04/04/2013 07:48PM
|
|
Re: Characters not getting stored
|
1,525 |
Andrea Croci
|
04/05/2013 01:00AM
|
|
Re: Characters not getting stored
|
1,339 |
Rick James
|
04/05/2013 11:07PM
|
|
This topic has been moved.:
How to insert 4bit character in mysql table?
|
0 |
Rama krishnan
|
08/03/2016 08:17AM
|
|
This topic has been moved.:
Data Migration from 5.6.29 to 5.7.12
|
0 |
Maurizio Scarano
|
06/02/2016 07:31PM
|
|
This topic has been moved.:
Characters not accepted
|
0 |
Ole Roger Dahle
|
03/13/2016 06:44PM
|