summaryrefslogtreecommitdiffstats
path: root/src/test/mb/sql/euc_kr.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/mb/sql/euc_kr.sql')
-rw-r--r--src/test/mb/sql/euc_kr.sql19
1 files changed, 19 insertions, 0 deletions
diff --git a/src/test/mb/sql/euc_kr.sql b/src/test/mb/sql/euc_kr.sql
new file mode 100644
index 0000000..cf9e07f
--- /dev/null
+++ b/src/test/mb/sql/euc_kr.sql
@@ -0,0 +1,19 @@
+drop table ͪߩѦ¿ë¾î;
+create table ͪߩѦ¿ë¾î (¿ë¾î text, ÝÂ×¾ÄÚµå varchar, ºñ°í1A¶ó±¸ char(16));
+create index ͪߩѦ¿ë¾îindex1 on ͪߩѦ¿ë¾î using btree (¿ë¾î);
+create index ͪߩѦ¿ë¾îindex2 on ͪߩѦ¿ë¾î using hash (ÝÂ×¾ÄÚµå);
+insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ', 'ѦA01ß¾');
+insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Åͱ׷¡ÇȽº', 'ÝÂB10ñé');
+insert into ͪߩѦ¿ë¾î values('ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó', 'ìÑZ01ù»');
+vacuum ͪߩѦ¿ë¾î;
+select * from ͪߩѦ¿ë¾î;
+select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå = 'ìÑZ01ù»';
+select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå ~* 'ìÑz01ù»';
+select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z01_';
+select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z%';
+select * from ͪߩѦ¿ë¾î where ¿ë¾î ~ 'ÄÄÇ»ÅÍ[µð±×]';
+select * from ͪߩѦ¿ë¾î where ¿ë¾î ~* 'ÄÄÇ»ÅÍ[µð±×]';
+select *,character_length(¿ë¾î) from ͪߩѦ¿ë¾î;
+select *,octet_length(¿ë¾î) from ͪߩѦ¿ë¾î;
+select *,position('µð' in ¿ë¾î) from ͪߩѦ¿ë¾î;
+select *,substring(¿ë¾î from 3 for 4) from ͪߩѦ¿ë¾î;