diff options
Diffstat (limited to 'src/test/mb/sql/euc_tw.sql')
-rw-r--r-- | src/test/mb/sql/euc_tw.sql | 20 |
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 ìÞÙ¸æñÕè; |