Concat_ws()

[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