Concat_ws()

[mjs7231]

I downloaded the trial version to see if the data sync would work. My findings were that your script uses the concat_ws function which is implimented differently in 4.0.14 and later. I am trying to sync two databases on both ends of this change.

Is there any plan to remove the use of this function, and possibly do the concat youself in the language which the app was written?

[peterlaursen]

……hmmmmmm

I have 3 comments.

1) That would burden the client with those calculations. So concat_ws() on the server side should continue to be used when ever possible.

2) Charset and collation implementations with various MySQL versions would have to be solved too. A table definition of 5.0 and 4.0 are NEVER identical – at least charset definitions differ. I am in doubt whether it can me done in a safe way. English-speaking people (like you?) always forget that there is more than one charset and more than 25 characteres!

3) There are some data type incompabilities. For instance: how to handle a varchar(1000) in a 5.0 database when syncing with a 4.0 database?

Low priority in my opinion. Unicode issues and localization is much more important.

[Ritesh]

We dont plan to implement concat_ws() on the client side. It will destroy the whole efficiency of the algorithm used in the data sync tool.

You will need to upgrade or downgrade your target server.

[Author]

Posts