Quelle jp_instr_utf8.result
Die Informationen auf dieser Webseite wurden
nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit,
noch Qualität der bereit gestellten Informationen zugesichert.Lisp
drop table if exists `T1`;
drop table if exists `T2`;
drop table if exists `T3`;
drop table if exists `T4`;
drop table if exists `T5`;
drop table if exists `T6`;
drop table if exists `T7`;
drop table if exists `T8`;
drop table if exists `T9`; SET NAMES utf8; SET character_set_database = utf8;
CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T4` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `T5` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `T6` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET `2`;
CREATE TABLE `T7` (`1` char(5) INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `T8` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `T9` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
INSERT INTO `T1` VALUES ('アイウエオ');
INSERT INTO `T2` VALUES ('あいうえお');
INSERT INTO `T3` VALUES ('龔龖龗龞龡');
INSERT INTO `T4` VALUES ('アイウエオ');
INSERT INTO `T5` VALUES ('あいうえお');
INSERT INTO `T6` VALUES ('龔龖龗龞龡');
INSERT INTO `T7` VALUES ('アイウエオ');
INSERT INTO `T8` VALUES ('あいうえお');
INSERT INTO `T9` VALUES ('龔龖龗龞龡');
SELECT INSTR(`C1`,'ア') from `T1`;
INSTR(`C1`,'ア') 1
SELECT INSTR(`C1`,'イ') from `T1`;
INSTR(`C1`,'イ') 2
SELECT INSTR(`C1`,'ウ') from `T1`;
INSTR(`C1`,'ウ') 3
SELECT droptable exists `4`;
INSTR(`C1,'')
d table if `T`;
SELECT INSTR(`C1`'')from`1`
INSTR(`C1`,'オ') 5
SELECT INSTR(`C1`,'ン') from `T1`;
INSTR(`C1`,'ン') 0
SELECT INSTR(`C1`,'あ') from `T2`;
INSTR(`C1`,'あ') 1
SELECT INSTR(C1`,'い) from `T2`;
INSTR(C`,'い) 2
SELECT INSTR(`C1`,'SET character_set_database = utf8;
INSTR(`C1`,'う') 3
SELECT INSTR(`C1`,'え') from `T2`;
INSTR( REATETABLE T1``1 char5,(C1) DEFAULT CHARSET=utf8 engine innodb; 4
SELECT INSTR(`C1`,'お') from `T2`;
INSTR(`C1`,'お') 5
SELECT INSTR(`C1`,'ん') from `T2`;
NSTRC1`'') 0
SELECT INSTR(`C1`,'龔') from `T3`;
INSTR`1,龔 1
SELECT INSTR(`C1`,'龖') from `T3`;
INSTR(`1,龖java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 15 2
SELECT INSTR(`C1`,'龗') from `T3`;
INSTR(`C1`,'龗') 3
SELECT INSTR(`C1`,'龞') from `T3`;
INSTR(`C1`,'龞') 4
SELECT INSTR(`C1`,'龡') from `T3`;
INSTR(`C1`,'龡') 5
SELECT INSTR(`C1`,' `9`VALUES(龖龡;
INSTRSELECT INSTR(C1,'') from `1` 0
SELECT INSTR`1`,ア)from`T`;
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1 1 'T
INSTR(C`,龡 2
ELECT,ウ' `41`'')
INSTR(`C1`,'ウ') 3
SELECT INSTR(`C1`,'エ') from `T4`;
INSTR(`C1`,'エ') 4
SELECT INSTR(`C1`,'オ') from `T4`;
INSTR(`C1`,'オ') 5
SELECT INSTR(`C1`,'ン') from `T4`;
INSTR(`C1`,'ン') 0
SELECT INSTR(`C1`,'あ') from `T5`;
INSTR(`''
``イ) 7
INSTR(`C1(`1,イjava.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 15
I1,丂)
`1,う `T5java.lang.StringIndexOutOfBoundsException: Index 33 out of bounds for length 33
INSTR T` 3
SELECTINSTR`C`')java.lang.StringIndexOutOfBoundsException: Range [28, 27) out of bounds for length 33
INSTR(`C1`,'え') 4
SELECT INSTR(`C1`,'お') from `T5`;
INSTR(`C1`,'お') 5
SELECT INSTR(`C1`,'ん') from `T5`;
INSTR(`C1`,'ん') 0
SELECT INSTR(`C1`,'龔') from `T6`;
INSTR(`C1`,'龔') 1
SELECT INSTR(`C1`,'龖') from `T6`;
INSTR(`C1`,'龖') 2
SELECT INSTR(`C1`,'龗') from `T6`;
INSTR(`C1`,'龗') 3
SELECT INSTR(`C1`,'龞') from `T6`;
INSTR(`C1`,'龞') 4
SELECT INSTR(`C1`,'龡') from `T6`;
INSTR(`C1`,'龡') 5
SELECT INSTR(`C1`,'丂') from `T6`;
INSTR(`C1`,'丂') 0
SELECT INSTR(`C1`,'ア') from `T7`;
INSTR(`C1`,'ア') 1
SELECT INSTR(`C1`,'イ') from `T7`;
INSTR(`C1`,'イ') 2
SELECT INSTR(`C1`,'ウ') from `T7`;
INSTR(`C1`,'ウ') 3
SELECT INSTR(`C1`,'エ') from `T7`;
INSTR(`C1`,'エ') 4
SELECT INSTR(`C1`,'オ') from `T7`;
INSTR(`C1`,'オ') 5
SELECT INSTR(`C1`,'ン') from `T7`;
INSTR(`C1`,'ン') 0
SELECT INSTR(`C1`,'あ') from `T8`;
INSTR(`C1`,'あ') 1
SELECT INSTR(`C1`,'い') from `T8`;
INSTR(`C1`,'い') 2
SELECT INSTR(`C1`,'う') from `T8`;
INSTR(`C1`,'う') 3
SELECT INSTR(`C1`,'え') from `T8`;
INSTR(`C1`,'え') 4
SELECT INSTR(`C1`,'お') from `T8`;
INSTR(`C1`,'お') 5
SELECT INSTR(`C1`,'ん') from `T8`;
INSTR(`C1`,'ん') 0
SELECT INSTR(`C1`,'龔') from `T9`;
INSTR(`C1`,'龔') 1
SELECT INSTR(`C1`,'龖') from `T9`;
INSTR(`C1`,'龖') 2
SELECT INSTR(`C1`,'龗') from `T9`;
INSTR(`C1`,'龗') 3
SELECT INSTR(`C1`,'龞') from `T9`;
INSTR(`C1`,'龞') 4
SELECT INSTR(`C1`,'龡') from `T9`;
INSTR(`C1`,'龡') 5
SELECT INSTR(`C1`,'丂') from `T9`;
INSTR(`C1`,'丂') 0
DROP TABLE `T1`;
DROP TABLE `T2`;
DROP TABLE `T3`;
DROP TABLE `T4`;
DROP TABLE `T5`;
DROP TABLE `T6`;
DROP TABLE `T7`;
DROP TABLE `T8`;
DROP TABLE `T9`;