Data Loader

CHAR Function in MSSQL and MySQL

CHAR function returns the Character value of the passed ASCII values. In MySQL CHAR function, you can pass multiple ASCII values separated by comma, Whereas in MS SQL Server you can pass only one ASCII value as argument, MSSQL Char function doesn't accept multiple arguments as in MySQL

MS SQL Server Example

select CHAR(98)

MSSQL CHAR function example
If you pass multiple arguments as in MySQL it will give error as shown below

select CHAR(98,97,99)

The CHAR function in

MSSQL Char Function example 2

MySQL Example

select CHAR(98)

MySQL Char function example

The MySQL CHAR function accepts multiple arguments as shown below

mysql> select CHAR(98,97,99);


MySQL Char function example 2


Back to Converting Functions from MSSQL to MySQL

The MSSQL to MySQL  converter will automatically convert the MSSQL functions to it's equivalent in MySQL while converting veiws.