Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
Description
I tested Microsoft SQL Server <=> MariaDB.
When you look at the record through the connect engine, it will look exactly.
However, when insert data from MariaDB, there is a space to the full length of the column in addition to the data inserted(I think that is pad). Even when the insert data is retrieved from the SQL Server, the entire length of the inserted recoed is filled full column length.
For example, select datalength(name) from testtb2; , The original data is the result value of 5, but the data inserted through MariaDB is equal to the column length of 50. like below.
1> select name from testtb2;
2> go
name
--------------------------------------------------
test1
test2
test3
74716
test4
(5 rows affected)
1> select datalength(name) from testtb2;
2> go
-----------
5
5
5
50 <=== inserted from MariaDB using connect engine.
50 <=== inserted from MariaDB using connect engine.
(5 rows affected)
If it is something that can be improved, I think it would be better for the user to improve it.
Would it be possible to improve?!