Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/jp/t/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 7 kB

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 `�ԣ�`;