CODEWITHSUNDEEP
postgresqlpostgresql-9.5
Sandeep
Sandeep

Reputation: 721

Removing French words from database

I have a Ecommerce database where the company is providing support in different countries (France and UK). But the company focuses mainly in UK and has a data warehouse which they dump the data from Magento.

In a few tables like PRODUCTS and all some French wordings are listed. I need to avoid it and make complete data to be available in English.

How can I remove the existing French wordings (there might be many tables and many columns) from the database and replace it with English?

Do you have any suggestions on which how this can be done?

Upvotes: 1

Views: 44

Answers (1)

Sandeep
Sandeep

Reputation: 721

The french words are coming from Magento products and category tables, Have filtered the values where "STORE_ID=0" , This will take only the global values.

Upvotes: 1

Related Questions