Quelle jp_charset_ucs2.test Sprache: unbekannt

Spracherkennung für: .test vermutete Sprache: SQL {SQL[126] R[54] VDM[54]} [Methode: maximale Elemente, drei Dimensionen]

--source include/have_sjis.inc
--source include/have_ucs2.inc
--source include/have_ujis.inc
--source include/have_utf8.inc
--source include/have_innodb.inc

--disable_warnings
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
drop table if exists `�ԣ�`;
--enable_warnings

#
# Test CHARSET() function with Japanese characters in ucs2 encoding
#

SET NAMES ujis;
SET character_set_database = ucs2;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = MEMORY;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = MEMORY;
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ucs2 engine = MEMORY;

#Insert the following data in each table
# jisx0201 hankaku-katakana data
# jisx0208 data
# jisx0212 supplemental character data

INSERT INTO `�ԣ�` VALUES
('PQRSTUVWXYZ[\\]^_')
,(' ��')
,('��')
,('��ŽÎĎŎƎǎȎɎʎˎ͎̎Ύ�')
,('�ЎюҎӎԎՎ֎׎؎َڎێ܎ݎގ�');

INSERT INTO `�ԣ�` VALUES
('��¡áġšơ�')
,('�ȡɡʡˡ̡͡ΡϡСѡҡӡԡա֡סء١ڡ�')
,('��')
,('��')
,('��')
,('��СТУФХЦЧШЩЪЫЬЭЮЯабвг')
,('��');

INSERT INTO `�ԣ�` VALUES
('��Ï�ġ��')
,('��Ï�ď�ŏ�Ə��')
,('��ȏ�ɏ�ʏ�ˏ�̏�͏�Ώ�Ϗ�Џ�я�ҏ�ӏ�ԏ�Տ�֏�׏�؏�ُ�ڏ��')
,('��܏�ݏ�ޏ�ߏ��Ᏸ⏰㏰䏰台揰珰菰鏰ꏰ돰쏰폰�')
,('��')
,('��Ï�ď�ŏ�Ə��')
,('��ȏ�ɏ�ʏ�ˏ�̏�͏�Ώ�Ϗ�Џ�я�ҏ�ӏ�ԏ�Տ�֏�׏�؏�ُ�ڏ��');

INSERT INTO `�ԣ�` VALUES
('PQRSTUVWXYZ[\\]^_')
,(' ��')
,('��')
,('��ŽÎĎŎƎǎȎɎʎˎ͎̎Ύ�')
,('�ЎюҎӎԎՎ֎׎؎َڎێ܎ݎގ�');

INSERT INTO `�ԣ�` VALUES
('��¡áġšơ�')
,('�ȡɡʡˡ̡͡ΡϡСѡҡӡԡա֡סء١ڡ�')
,('��')
,('��')
,('��')
,('��СТУФХЦЧШЩЪЫЬЭЮЯабвг')
,('��');

INSERT INTO `�ԣ�` VALUES
('��Ï�ġ��')
,('��Ï�ď�ŏ�Ə��')
,('��ȏ�ɏ�ʏ�ˏ�̏�͏�Ώ�Ϗ�Џ�я�ҏ�ӏ�ԏ�Տ�֏�׏�؏�ُ�ڏ��')
,('��܏�ݏ�ޏ�ߏ��Ᏸ⏰㏰䏰台揰珰菰鏰ꏰ돰쏰폰�')
,('��')
,('��Ï�ď�ŏ�Ə��')
,('��ȏ�ɏ�ʏ�ˏ�̏�͏�Ώ�Ϗ�Џ�я�ҏ�ӏ�ԏ�Տ�֏�׏�؏�ُ�ڏ��');

INSERT INTO `�ԣ�` VALUES
('PQRSTUVWXYZ[\\]^_')
,(' ��')
,('��')
,('��ŽÎĎŎƎǎȎɎʎˎ͎̎Ύ�')
,('�ЎюҎӎԎՎ֎׎؎َڎێ܎ݎގ�');

INSERT INTO `�ԣ�` VALUES
('��¡áġšơ�')
,('�ȡɡʡˡ̡͡ΡϡСѡҡӡԡա֡סء١ڡ�')
,('��')
,('��')
,('��')
,('��СТУФХЦЧШЩЪЫЬЭЮЯабвг')
,('��');

INSERT INTO `�ԣ�` VALUES
('��Ï�ġ��')
,('��Ï�ď�ŏ�Ə��')
,('��ȏ�ɏ�ʏ�ˏ�̏�͏�Ώ�Ϗ�Џ�я�ҏ�ӏ�ԏ�Տ�֏�׏�؏�ُ�ڏ��')
,('��܏�ݏ�ޏ�ߏ��Ᏸ⏰㏰䏰台揰珰菰鏰ꏰ돰쏰폰�')
,('��')
,('��Ï�ď�ŏ�Ə��')
,('��ȏ�ɏ�ʏ�ˏ�̏�͏�Ώ�Ϗ�Џ�я�ҏ�ӏ�ԏ�Տ�֏�׏�؏�ُ�ڏ��');

#InnoDB
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;

#MyISAM
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;

#MEMORY
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;

drop table `�ԣ�`;
drop table `�ԣ�`;
drop table `�ԣ�`;
drop table `�ԣ�`;
drop table `�ԣ�`;
drop table `�ԣ�`;
drop table `�ԣ�`;
drop table `�ԣ�`;
drop table `�ԣ�`;

Quelle jp_charset_ucs2.test Sprache: unbekannt

[Dauer der Verarbeitung: 0.11 Sekunden, vorverarbeitet 2026-10-10]