we’re using derby in one of our products. With the new version of our product we are facing a collation problem. For creating new databases on application setup we use the collation option TERRITORY_BASED. Older versions of our app did not use the collation parameter. So we need to find a way for altering the collation of these existing databases to territory based. Do you see any way to achieve this?
Thanks for your input.