In MySQL, the ICU_VERSION() function returns the version of the International Components for Unicode (ICU) library used to support regular expression operations.

The ICU_VERSION() function is primarily intended for use in test cases.

Syntax

The syntax goes like this:

ICU_VERSION()

No arguments are required or accepted.

Example

We can use the function in a SELECT statement, like this:

SELECT ICU_VERSION();

Result:

+---------------+
| ICU_VERSION() |
+---------------+
| 70.1          |
+---------------+

This is what I got on my system when I ran that statement, however, your result will depend on your system. For example, when I ran it on a different system, the result was 65.1.

No Arguments

As mentioned, ICU_VERSION() doesn’t accept any arguments. Here’s what happens if we pass an argument:

SELECT ICU_VERSION( 1 );

Result:

ERROR 1582 (42000): Incorrect parameter count in the call to native function 'ICU_VERSION'