create table word(
en_word text null,
zh_word text null
);
insert into word values('Internet', '互联网');
insert into word values('Hello', '你好');
INVALID QUERY:
select
LENGTH(en_word) as 'English Length',
LENGTH(zh_word) 'Zh word length'
from word;
VALID QUERY:
select
CHAR_LENGTH(en_word) as 'English Length',
CHAR_LENGTH(zh_word) 'Zh word length'
from word;
en_word text null,
zh_word text null
);
insert into word values('Internet', '互联网');
insert into word values('Hello', '你好');
INVALID QUERY:
select
LENGTH(en_word) as 'English Length',
LENGTH(zh_word) 'Zh word length'
from word;
VALID QUERY:
select
CHAR_LENGTH(en_word) as 'English Length',
CHAR_LENGTH(zh_word) 'Zh word length'
from word;
LENGTH returns length in bytes (and chinese is multibyte)
Use CHAR_LENGTH to get length in characters
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_char-length
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length
Use CHAR_LENGTH to get length in characters
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_char-length
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length