数据库中,某属性的属性值中有中文,英文还有中英文混合的。如何统计该属性中属性值为中文的数量和?
如统计下表name属性中属性值为中文的有6个:
time name
2007-12-15 19:38 download
2007-12-16 13:07 log
2007-01-21 10:09 ss
2007-12-15 15:43 oracle
2007-10-30 15:05 test
2007-12-20 17:35 a.txt
2007-06-25 21:12 music
2007-09-06 20:47 eclipse
2007-12-15 15:28 实验数据
2007-12-14 22:02 result.ctl
2006-11-01 14:54 网页
2007-10-31 13:03 towangchao
2007-09-05 14:30 workspace
2007-12-14 10:37 aa.txt
2006-11-29 20:27 googleTest
2006-11-29 20:28 soapsearch
2006-11-29 21:34 备份
2007-10-30 16:33 towangchao.rar
2007-12-18 21:49 数据库设计方法
2007-11-15 18:12 oracle 学习.do
2007-08-20 08:43 HTML_Parser
2007-09-08 08:04 workspace2
2007-12-16 12:11 error.txt
2007-12-14 22:10 result.log
2007-12-15 15:36 sql.txt
2007-09-28 10:46 程序资料
2007-08-31 18:13 java视频教程
2007-12-14 12:54 sqlnet.log
2007-12-16 11:18 清理临时表空间
2007-12-04 17:25 books.html
2007-12-16 19:26 Tencent
2007-12-18 21:49 oracle电子文档
如统计下表name属性中属性值为中文的有6个:
time name
2007-12-15 19:38 download
2007-12-16 13:07 log
2007-01-21 10:09 ss
2007-12-15 15:43 oracle
2007-10-30 15:05 test
2007-12-20 17:35 a.txt
2007-06-25 21:12 music
2007-09-06 20:47 eclipse
2007-12-15 15:28 实验数据
2007-12-14 22:02 result.ctl
2006-11-01 14:54 网页
2007-10-31 13:03 towangchao
2007-09-05 14:30 workspace
2007-12-14 10:37 aa.txt
2006-11-29 20:27 googleTest
2006-11-29 20:28 soapsearch
2006-11-29 21:34 备份
2007-10-30 16:33 towangchao.rar
2007-12-18 21:49 数据库设计方法
2007-11-15 18:12 oracle 学习.do
2007-08-20 08:43 HTML_Parser
2007-09-08 08:04 workspace2
2007-12-16 12:11 error.txt
2007-12-14 22:10 result.log
2007-12-15 15:36 sql.txt
2007-09-28 10:46 程序资料
2007-08-31 18:13 java视频教程
2007-12-14 12:54 sqlnet.log
2007-12-16 11:18 清理临时表空间
2007-12-04 17:25 books.html
2007-12-16 19:26 Tencent
2007-12-18 21:49 oracle电子文档
length(字段)=lengthb(字段) -》英文或字符
<> -》含中文,根据编码不同,1个汉字可能占2个或3个
貌似也有汉字占1个你可以尝试下这个方法