MySQL Forums :: Newbie :: how to retrieve only Chinese text from a table?


Advanced Search

how to retrieve only Chinese text from a table?
Posted by: Angelo Chen ()
Date: August 21, 2011 11:51PM

Hi,

I have a database with following info:

default character set utf8
default collation utf8_unicode_ci

a table:

CREATE TABLE `msg` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`msg` varchar(255) DEFAULT NULL,
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

above table has English and Chinese text in it, now, I'd like to retrieve only those Chinese text, possible? how?

Thanks,

Options: ReplyQuote


Subject Written By Posted
how to retrieve only Chinese text from a table? Angelo Chen 08/21/2011 11:51PM
Re: how to retrieve only Chinese text from a table? Rick James 08/23/2011 07:21PM
Re: how to retrieve only Chinese text from a table? Angelo Chen 08/26/2011 02:33AM
Re: how to retrieve only Chinese text from a table? Rick James 08/28/2011 01:47PM
Re: how to retrieve only Chinese text from a table? gougu gougu 08/26/2011 02:51AM


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.