MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Can one MySQL table column has multiple character sets supported at same time?
Posted by: Yongqin Xu
Date: June 14, 2006 01:05PM

I have a table column called "comments" that may need to save English (latin1), Chinese(big5), or Japanese at same time. That simply means, some records for this particular field will have Chinese; some will have Japanese; some are pure English. Now there is a web app that can view this field based on client locale. What mysql character set/collation I should set to the server, database, table, and column at those 4 levels? Does MySQL support multiple character sets at the same column at the same time?

As far as I know, you can only set one particular character set at one time at each level, then how do I do it?

thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to Insert Chinese into Mysql database with ASP
9955
Chetan Patel
May 24, 2005 01:59PM
Re: How to Insert Chinese into Mysql database with ASP
4446
Shuichi Tamagawa
May 25, 2005 11:31AM
Re: How to Insert Chinese into Mysql database with ASP
4273
Tetsuro Ikeda
May 25, 2005 11:33AM
Re: How to Insert Chinese into Mysql database with ASP
3096
Tetsuro Ikeda
May 25, 2005 11:36AM
Re: How to Insert Chinese into Mysql database with ASP
3011
Chetan Patel
September 19, 2005 02:13PM
Re: How to Insert Chinese into Mysql database with ASP
5579
Pernot Christian
September 21, 2005 03:05AM
Re: How to Insert Chinese into Mysql database with ASP
4426
Chetan Patel
September 22, 2005 07:58AM
Re: How to Insert Chinese into Mysql database with ASP
2985
Chetan Patel
September 28, 2005 03:34PM
Re: How to Insert Chinese into Mysql database with ASP
2892
Chetan Patel
September 28, 2005 03:42PM
Re: How to Insert Chinese into Mysql database with ASP
6328
Michael L Joseph
September 29, 2005 08:42PM
Re: How to Insert Chinese into Mysql database with ASP
2946
mail2anil17
November 24, 2005 08:36AM
Re: How to Insert Chinese into Mysql database with ASP
2897
mail2anil17
December 01, 2005 06:35AM
Re: How to Insert Chinese into Mysql database with ASP
2816
Mishar
October 13, 2006 09:50AM
Re: How to Insert Myanmar into Mysql database with xml
2933
kyawthi ha
January 26, 2006 01:34AM
How to Insert Myanmar into Mysql database with xml
4142
kyawthi ha
January 26, 2006 01:50AM
Re: How to Insert korean text into Mysql database with php
5222
lakhan lal
February 23, 2006 08:22AM
Can one MySQL table column has multiple character sets supported at same time?
5630
Yongqin Xu
June 14, 2006 01:05PM
Re: Can one MySQL table column has multiple character sets supported at same time?
3032
Geoffrey Lee
August 09, 2006 07:27AM


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.