MySQL :: MySQL Forums :: Character Sets, Collation, Unicode

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

Announcements	Last Post
• Announcing April 2026 Releases featuring MySQL Server 9.7.0, 8.4.9 and 8.0.46	04/27/2026 03:22AM

New Topic

Pages:

« 1 2 3 4 5

...

22 »

Subject

Views

Written By

Posted

All Emoji Not Stored in Mysql Database

7,188

RANJIT SONI

10/26/2017 03:02AM

Collations in MySQL 8.0

1,716

Edwin Desouza

09/29/2017 09:30AM

View with a search for a field containing special characters

4,100

Roberto Compare

07/18/2017 06:57AM

Re: View with a search for a field containing special characters

1,118

Peter Brawley

07/18/2017 09:59AM

How to compare gujarati string from mysql with text file.

1,932

Dikshan Shah

07/17/2017 10:55PM

MySQL 8.0: Kana-sensitive collation for Japanese

1,809

Edwin Desouza

06/15/2017 10:40AM

MySQL Debugging Character Set Issues by Example

1,537

Edwin Desouza

06/13/2017 08:43AM

How to use the GB18030 character set in mysql5.6?

1,761

Paul Yu

06/07/2017 01:42AM

Re: How to use the GB18030 character set in mysql5.6?

1,002

Paul Yu

06/07/2017 01:54AM

Re: How to use the GB18030 character set in mysql5.6?

910

Abdullah Prem

06/12/2017 01:58PM

Re: How to use the GB18030 character set in mysql5.6?

897

David Stokes

06/13/2017 06:49AM

pound as backwards question mark

2,281

Pamela Whittaker

05/13/2017 04:26PM

Re: pound as backwards question mark

1,092

Peter Brawley

05/14/2017 12:44AM

Re: pound as backwards question mark

1,107

Pamela Whittaker

05/15/2017 10:51AM

Re: pound as backwards question mark

1,095

Peter Brawley

05/15/2017 02:25PM

Re: pound as backwards question mark

990

Pamela Whittaker

05/16/2017 01:57AM

Re: pound as backwards question mark

1,045

Peter Brawley

05/19/2017 11:35PM

Re: pound as backwards question mark

1,024

Pamela Whittaker

05/20/2017 02:11AM

MySQL 8.0: When to use utf8mb3 over utf8mb4?

1,682

Edwin Desouza

05/19/2017 01:18PM

blob data to infile

2,026

Charles Kaminski

04/27/2017 12:07PM

Re: blob data to infile

902

Charles Kaminski

04/27/2017 12:13PM

Re: blob data to infile

1,140

Charles Kaminski

04/28/2017 02:53PM

Re: blob data to infile

950

Charles Kaminski

05/04/2017 10:53AM

MySQL 8.0 Collations: Migrating from older collations

1,553

Edwin Desouza

04/24/2017 10:49AM

MySQL 8.0.1: Japanese collation for utf8mb4

1,809

Edwin Desouza

04/17/2017 08:18AM

MySQL 8.0.1: Accent and case sensitive collations for utf8mb4

2,357

Edwin Desouza

04/13/2017 10:41AM

Complete Example a la Hello World

1,655

Matha Goram

04/07/2017 06:56AM

MySQL 8.0 Collations: The devil is in the details.

1,638

Edwin Desouza

03/28/2017 10:26AM

Re: MySQL 8.0 Collations: The devil is in the details.

841

Peter Brawley

03/28/2017 02:20PM

Is this bug in MySQL Server 5.7.14?

2,946

Мих ТехСпец

03/26/2017 07:41AM

Re: Is this bug in MySQL Server 5.7.14?

1,192

Peter Brawley

03/26/2017 10:43AM

Re: Is this bug in MySQL Server 5.7.14?

1,393

Мих ТехСпец

03/26/2017 11:33AM

Re: Is this bug in MySQL Server 5.7.14?

1,259

Peter Brawley

03/26/2017 12:11PM

Re: Is this bug in MySQL Server 5.7.14?

1,174

Мих ТехСпец

03/26/2017 12:24PM

Re: Is this bug in MySQL Server 5.7.14?

1,107

Peter Brawley

03/26/2017 02:34PM

Re: Is this bug in MySQL Server 5.7.14?

1,181

Мих ТехСпец

03/27/2017 04:50AM

Re: Is this bug in MySQL Server 5.7.14?

1,159

Peter Brawley

03/27/2017 10:56AM

Re: Is this bug in MySQL Server 5.7.14?

1,187

Мих ТехСпец

03/27/2017 12:33PM

Re: Is this bug in MySQL Server 5.7.14?

1,716

Peter Brawley

03/27/2017 02:55PM

Re: Is this bug in MySQL Server 5.7.14?

1,154

Мих ТехСпец

03/27/2017 03:03PM

Re: Is this bug in MySQL Server 5.7.14?

1,082

Peter Brawley

03/27/2017 03:32PM

Re: Is this bug in MySQL Server 5.7.14?

1,244

Мих ТехСпец

03/27/2017 10:10PM

Re: Is this bug in MySQL Server 5.7.14?

1,056

Peter Brawley

03/27/2017 10:17PM

MySQL 8.0: New collations UTF-8

1,484

Edwin Desouza

03/16/2017 01:04PM

MySQL 8.0: UTF8, Collations, Unicode

1,811

Edwin Desouza

02/06/2017 01:38PM

MySLQ 8.0: Sushi = Beer ?! An introduction of UTF8 support

1,556

Edwin Desouza

02/06/2017 01:37PM

No ascii characters from java

1,989

michael Mauro

01/16/2017 05:39AM

Re: No ascii characters from java

885

Peter Brawley

01/16/2017 09:30AM

Re: No ascii characters from java

945

michael Mauro

01/19/2017 07:41AM

4 byte emoji chars displayed as ?? when Japanese characters included

3,704

01/08/2017 03:00PM

Re: 4 byte emoji chars displayed as ?? when Japanese characters included

1,172

Peter Brawley

01/08/2017 04:19PM

Re: 4 byte emoji chars displayed as ?? when Japanese characters included

1,303

01/08/2017 04:49PM

Re: 4 byte emoji chars displayed as ?? when Japanese characters included

1,210

01/08/2017 05:31PM

Re: 4 byte emoji chars displayed as ?? when Japanese characters included

1,060

Peter Brawley

01/08/2017 08:12PM

Re: 4 byte emoji chars displayed as ?? when Japanese characters included

1,252

Xing Zhang

01/09/2017 08:06PM

MySQL utf-8 issue with json

3,829

Mehmet Akif Kardas

10/25/2016 07:00AM

Re: MySQL utf-8 issue with json

1,386

Rick James

10/26/2016 08:20PM

Re: MySQL utf-8 issue with json

1,188

Mehmet Akif Kardas

10/27/2016 09:02AM

How to get SELECT COERCIBILITY(xxx)=1?

2,071

Huanting Liu

09/06/2016 10:07PM

HUANTING LIU - more about collations

1,921

Rick James

08/14/2016 06:30PM

Re: HUANTING LIU - more about collations

1,114

huanting liu

08/15/2016 10:21AM

Error Code 1300: Invalid utf8 character string

54,607

Michaela Metzger

08/09/2016 01:40PM

Re: Error Code 1300: Invalid utf8 character string

16,763

Peter Brawley

08/09/2016 02:41PM

Re: Error Code 1300: Invalid utf8 character string

17,679

Michaela Metzger

08/09/2016 03:35PM

Re: Error Code 1300: Invalid utf8 character string

16,103

Rick James

08/14/2016 06:33PM

Where can I find information about utf8mb4_general_ci?

2,759

HUANTING LIU

08/04/2016 08:56PM

How to insert 4bit character in mysql table?

2,441

Rama krishnan

08/01/2016 11:49PM

Re: How to insert 4byte character in mysql table?

1,250

Rick James

08/03/2016 02:59PM

Trying NOT to remove accentation

2,187

Milos Losmi

06/10/2016 07:38AM

Re: Trying NOT to remove accentation

1,390

Peter Brawley

06/10/2016 08:55AM

Re: Trying NOT to remove accentation

1,092

Jeremy Smyth

06/10/2016 10:12AM

Re: Trying NOT to remove accentation

1,192

Rick James

06/13/2016 02:01AM

Re: Trying NOT to remove accentation

1,144

Milos Losmi

06/16/2016 01:15AM

Data Migration from 5.6.29 to 5.7.12

3,147

Maurizio Scarano

06/02/2016 06:40AM

Re: Data Migration from 5.6.29 to 5.7.12

1,191

Peter Brawley

06/10/2016 09:02AM

Re: Data Migration from 5.6.29 to 5.7.12

1,096

Rick James

06/13/2016 11:00AM

Greek.xml on charsets

1,999

Δημήτριος Θεοδωρόπουλος

04/20/2016 09:32AM

Re: Greek.xml on charsets

1,059

Rick James

04/22/2016 06:22PM

How to get rid of VT FF etc. special chars

2,562

Thomas H.

03/30/2016 01:16AM

Re: How to get rid of VT FF etc. special chars

1,216

Rick James

03/31/2016 09:30AM

Characters not accepted

3,603

Ole Roger Dahle

03/13/2016 09:01AM

Re: Characters not accepted

1,116

Rick James

03/15/2016 08:29PM

Re: Characters not accepted

1,109

Peter Brawley

03/30/2016 09:13AM

Byte level storage seems right, display seems wrong

2,352

02/25/2016 11:35AM

Re: Byte level storage seems right, display seems wrong

1,305

Rick James

02/26/2016 01:36PM

Re: Byte level storage seems right, display seems wrong

1,277

02/26/2016 02:56PM

Re: Byte level storage seems right, display seems wrong

1,328

Rick James

03/05/2016 01:10AM

An UTF8 oddity

2,240

Chris Devine

02/23/2016 11:00AM

Re: An UTF8 oddity

1,144

Chris Devine

02/23/2016 12:45PM

Re: An UTF8 oddity

1,033

Rick James

02/26/2016 09:11PM

Store mathematical equations in MySql DB

11,930

Karthik Babu

02/09/2016 12:59AM

Re: Store mathematical equations in MySql DB

4,467

Jon Stephens

02/09/2016 03:43AM

Re: Store mathematical equations in MySql DB

2,708

Rick James

02/16/2016 10:51PM

can't insert that character 💀

1,950

Ersin KARAKADIOĞLU

02/02/2016 08:42AM

Re: can't insert that character 💀

1,084

Peter Brawley

02/02/2016 04:50PM

Re: can't insert that character 💀

991

batuhan arol

02/16/2016 05:59AM

Re: can't insert that character 💀

1,020

Ersin KARAKADIOĞLU

02/03/2016 12:12AM

Database names created with 4-byte characters displayed as ???

2,028

Jennifer Roos

12/10/2015 12:50PM

Re: Database names created with 4-byte characters displayed as ???

1,140

Rick James

12/15/2015 11:13AM

ORDER BY - why doesnt it work??

2,284

Simon Gabor

11/19/2015 06:59AM

Re: ORDER BY - why doesnt it work??

1,015

Jeremy Smyth

11/19/2015 07:22AM

Re: ORDER BY - why doesnt it work??

1,057

Simon Gabor

11/19/2015 07:27AM

Can someone help me explain what is going on

1,979

10/20/2015 04:10AM

Re: Can someone help me explain what is going on

1,081

Rick James

10/24/2015 10:59PM

load data infile ... with UTF-8 characters

9,125

Bruce Malmat

09/05/2015 05:42PM

Re: load data infile ... with UTF-8 characters

2,286

Xing Zhang

09/13/2015 08:18PM

Re: load data infile ... with UTF-8 characters

2,228

Bruce Malmat

09/14/2015 02:05PM

Re: load data infile ... with UTF-8 characters

1,845

Rick James

09/16/2015 01:16PM

Re: load data infile ... with UTF-8 characters

2,112

Bruce Malmat

09/16/2015 04:01PM

Re: load data infile ... with UTF-8 characters

1,725

Bruce Malmat

09/17/2015 01:21PM

Re: load data infile ... with UTF-8 characters

1,690

Rick James

09/18/2015 09:24PM

Re: load data infile ... with UTF-8 characters

2,025

Bruce Malmat

09/23/2015 11:49AM

Re: load data infile ... with UTF-8 characters

1,545

Xing Zhang

09/29/2015 01:12AM

Re: load data infile ... with UTF-8 characters

1,792

Rick James

10/02/2015 03:51PM

Re: load data infile ... with UTF-8 characters

1,693

Bruce Malmat

10/02/2015 05:28PM

Re: load data infile ... with UTF-8 characters

1,853

Rick James

10/02/2015 09:17PM

Re: load data infile ... with UTF-8 characters

1,962

Bruce Malmat

10/02/2015 09:54PM

MySQL returns the same result using the IN clause irrespective of the value used

2,566

Deepthi Pullannagari

07/15/2015 11:07AM

Re: MySQL returns the same result using the IN clause irrespective of the value used

1,297

Peter Brawley

07/15/2015 01:55PM

Re: MySQL returns the same result using the IN clause irrespective of the value used

1,291

Rick James

07/17/2015 03:49PM

Can't insert the '&' character ...

2,338

07/10/2015 03:01AM

Re: Can't insert the '&' character ...

1,392

Rick James

07/11/2015 02:27PM

[For Polish mysql programmers mainly] Retrieving character ł in query

3,226

Mikey Terracano

05/14/2015 12:34AM

Re: [For Polish mysql programmers mainly] Retrieving character ł in query

1,431

Rick James

05/17/2015 11:25AM

1273 - Unknown collation: 'utf8mb4_unicode_ci' error

22,192

Paolo Bergomi

05/04/2015 10:30AM

Re: 1273 - Unknown collation: 'utf8mb4_unicode_ci' error

5,734

Paolo Bergomi

05/05/2015 08:48AM

Like operator and cyrillic symbols with MySQL and jdbc

3,785

Arthur Harkivskyi

03/29/2015 08:12AM

Re: Like operator and cyrillic symbols with MySQL and jdbc

1,888

Arthur Harkivskyi

03/29/2015 08:17AM

Re: Like operator and cyrillic symbols with MySQL and jdbc

1,713

Rick James

04/01/2015 03:37PM

Re: Like operator and cyrillic symbols with MySQL and jdbc

1,380

Rick James

04/01/2015 03:39PM

hostname not set correctly on MySQL 5.6 on Korean Windows

3,134

Jennifer Roos

03/04/2015 02:47PM

Re: hostname not set correctly on MySQL 5.6 on Korean Windows

1,521

Rick James

03/06/2015 09:57AM

Re: hostname not set correctly on MySQL 5.6 on Korean Windows

1,508

Jennifer Roos

03/06/2015 04:06PM

Re: hostname not set correctly on MySQL 5.6 on Korean Windows

1,433

Rick James

03/08/2015 12:06AM

Re: hostname not set correctly on MySQL 5.6 on Korean Windows

1,492

Jennifer Roos

03/09/2015 08:57AM

Re: hostname not set correctly on MySQL 5.6 on Korean Windows

1,594

Rick James

03/12/2015 04:49PM

Re: hostname not set correctly on MySQL 5.6 on Korean Windows

1,490

Jennifer Roos

03/13/2015 12:58PM

Re: hostname not set correctly on MySQL 5.6 on Korean Windows

1,406

Rick James

03/14/2015 10:29AM

What will be the best Data-type to store md5\sha1 hashes in MySQL?

9,748

02/04/2015 06:24AM

Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?

4,271

Rick James

02/05/2015 06:57PM

Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?

2,638

02/11/2015 01:33AM

Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?

2,214

Rick James

02/12/2015 12:13AM

Collation Weirdness with UNION in VIEW

4,856

11/25/2014 11:16AM

Re: Collation Weirdness with UNION in VIEW

1,790

Rick James

11/26/2014 10:56AM

Replace command & backslash

4,554

11/16/2014 03:03AM

Re: Replace command & backslash

1,621

Rick James

11/17/2014 12:10AM

Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

35,705

Muhammad Ali

10/04/2014 03:11AM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

7,344

Muhammad Ali

10/04/2014 04:37AM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

5,307

Muhammad Ali

10/06/2014 05:00AM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

6,660

Rick James

10/07/2014 04:20PM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

5,972

Muhammad Ali

10/10/2014 07:50AM

This topic has been moved.: View with a search for a field containing special characters

7

Roberto Compare

07/18/2017 09:47AM

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

Pages:

« 1 2 3 4 5

...

22 »

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.