MariaDB ASCII関数で複数の文字のアスキーコードを調べる方法

環境
MariaDB 10.6.4
Windows 10 Home 64bit

書式
ASCII( 文字列 )
引数が文字列で指定された場合は、先頭(左端)の文字のアスキーコードを返します。

使用例
引数が複数の文字の場合

SQL構文
SELECT ASCII( 'd’ ), ASCII( 'dbc’ ), ASCII( 'DSCII’ );

実行結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
MariaDB [(none)]> SELECT ASCII( 'd' ), ASCII( 'dbc' ), ASCII( 'DSCII' );
+--------------+----------------+------------------+
| ASCII( 'd' ) | ASCII( 'dbc' ) | ASCII( 'DSCII' ) |
+--------------+----------------+------------------+
| 100 | 100 | 68 |
+--------------+----------------+------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT ASCII( 'd' ), ASCII( 'dbc' ), ASCII( 'DSCII' ); +--------------+----------------+------------------+ | ASCII( 'd' ) | ASCII( 'dbc' ) | ASCII( 'DSCII' ) | +--------------+----------------+------------------+ | 100 | 100 | 68 | +--------------+----------------+------------------+ 1 row in set (0.000 sec)
MariaDB [(none)]> SELECT ASCII( 'd' ), ASCII( 'dbc' ), ASCII( 'DSCII' );
+--------------+----------------+------------------+
| ASCII( 'd' ) | ASCII( 'dbc' ) | ASCII( 'DSCII' ) |
+--------------+----------------+------------------+
|          100 |            100 |               68 |
+--------------+----------------+------------------+
1 row in set (0.000 sec)

 

MariaDB

Posted by arkgame