1 files changed, 20 insertions, 0 deletions

diff --git a/src/test/mb/sql/euc_tw.sql b/src/test/mb/sql/euc_tw.sql
new file mode 100644
index 0000000..79f3def
--- /dev/null
+++ b/src/test/mb/sql/euc_tw.sql
@@ -0,0 +1,20 @@
+drop table ìÞÙ¸æñÕè;
+create table ìÞÙ¸æñÕè (ÈçäÆɱ text, ÄüƳÍñó¤ varchar, ÇâÉß varchar(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 6 ) from ìÞÙ¸æñÕè;