Mac De Oracle Heterogeneous! #70 Tweet

前回のつづき。Generic Connectivyty経由でMySQL4.1.13aの文字型にアクセス。準備。

MySQL4.0.13aは、Generic Connectivityを介して以下の経路でアクセスする。
（尚、MySQL4.0.25のまとめは、MySQL4.1.13aのまとめに含める予定である。）

１．準備

MacOSX Serverに構築したMySQL4.1.13aには、char_test表と、varchar_test表を作成してあり、以下のようなデータを登録しておいた。

mysql> select
    ->   id,
    ->   r_char_20,
    ->   r_char_20_binary
    -> from
    ->   char_test;
+----+------------------------------------------+------------------------------------------+
| id | r_char_20                                | r_char_20_binary                         |
+----+------------------------------------------+------------------------------------------+
|  1 |  あ                                      | NULL                                     |
|  2 | NULL                                     | NULL                                     |
|  3 |                                          | NULL                                     |
|  4 | 12345678901234567890                     | NULL                                     |
|  5 | １２３４５６７８９０１２３４５６７８９０ | NULL                                     |
|  6 | NULL                                     |  あ                                      |
|  7 | NULL                                     | NULL                                     |
|  8 | NULL                                     |                                          |
|  9 | NULL                                     | 12345678901234567890                     |
| 10 | NULL                                     | １２３４５６７８９０１２３４５６７８９０ |
+----+------------------------------------------+------------------------------------------+
10 rows in set (0.02 sec)

mysql> 
mysql> select
    ->   id,
    ->   length(r_char_255),
    ->   length(r_char_255_binary)
    -> from
    ->   char_test
    -> where
    ->   id = 11;
+----+--------------------+---------------------------+
| id | length(r_char_255) | length(r_char_255_binary) |
+----+--------------------+---------------------------+
| 11 |                255 |                       255 |
+----+--------------------+---------------------------+
1 row in set (0.07 sec)

mysql> 
mysql> select 
    ->   id,
    ->   r_varchar_20,
    ->   r_varchar_20_binary
    -> from
    ->   varchar_test;
+----+--------------+---------------------+
| id | r_varchar_20 | r_varchar_20_binary |
+----+--------------+---------------------+
|  1 | C            | C                   |
|  2 | c            | c                   |
|  3 | B            | B                   |
|  4 | b            | b                   |
|  5 | A            | A                   |
|  6 | a            | a                   |
|  7 | お           | お                  |
|  8 | え           | え                  |
|  9 | う           | う                  |
| 10 | い           | い                  |
| 11 | あ           | あ                  |
| 12 | ぉ           | ぉ                  |
| 13 | ぇ           | ぇ                  |
| 14 | ぅ           | ぅ                  |
| 15 | ぃ           | ぃ                  |
| 16 | ぁ           | ぁ                  |
| 17 | NULL         | NULL                |
| 18 |              |                     |
+----+--------------+---------------------+
18 rows in set (0.00 sec)

mysql> 
mysql> select
    ->   id,
    ->   r_varchar_20,
    ->   r_varchar_20_binary
    -> from
    ->   varchar_test
    -> where
    ->   id between 19 and 28;
+----+------------------------------------------+------------------------------------------+
| id | r_varchar_20                             | r_varchar_20_binary                      |
+----+------------------------------------------+------------------------------------------+
| 19 |  あ                                      | NULL                                     |
| 20 | NULL                                     | NULL                                     |
| 21 |                                          | NULL                                     |
| 22 | 12345678901234567890                     | NULL                                     |
| 23 | １２３４５６７８９０１２３４５６７８９０ | NULL                                     |
| 24 | NULL                                     |  あ                                      |
| 25 | NULL                                     | NULL                                     |
| 26 | NULL                                     |                                          |
| 27 | NULL                                     | 12345678901234567890                     |
| 28 | NULL                                     | １２３４５６７８９０１２３４５６７８９０ |
+----+------------------------------------------+------------------------------------------+
10 rows in set (0.02 sec)

mysql> 
mysql> select
    ->   id,
    ->   length(r_varchar_255),
    ->   length(r_varchar_255_binary)
    -> from
    ->   varchar_test
    -> where
    ->   id = 29;
+----+-----------------------+------------------------------+
| id | length(r_varchar_255) | length(r_varchar_255_binary) |
+----+-----------------------+------------------------------+
| 29 |                   255 |                          255 |
+----+-----------------------+------------------------------+
1 row in set (0.00 sec)

mysql> select
    ->   id,
    ->   length(r_tinytext),
    ->   length(r_tinyblob)
    -> from
    ->   varchar_test
    -> where
    ->   id = 30;
+----+--------------------+--------------------+
| id | length(r_tinytext) | length(r_tinyblob) |
+----+--------------------+--------------------+
| 30 |                255 |                255 |
+----+--------------------+--------------------+
1 row in set (0.00 sec)

mysql> select
    ->   id,
    ->   length(r_text),
    ->   length(r_blob)
    -> from
    ->   varchar_test
    -> where
    ->   id between 31 and 34;
+----+----------------+----------------+
| id | length(r_text) | length(r_blob) |
+----+----------------+----------------+
| 31 |           2000 |           2000 |
| 32 |           2001 |           2001 |
| 33 |           4000 |           4000 |
| 34 |           4001 |           4001 |
+----+----------------+----------------+
4 rows in set (0.00 sec)

mysql> 

今日はここまで、次回へつづく。