MySQL Forums
Forum List  »  Newbie

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?
August 21, 2011 11:51PM


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.