As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1599001
Capitalizing accented letters and other characters in database
Closed

Comments

  • Afsaneh started the conversation

    Hi,

    How to format a column of the database in uppercase?
    I need to change the case but not in CSS but  in the database


    Example : 
    "Cédric" in a field = "CEDRIC" in database.

    Thanks for your help

  • [deleted] replied

    Hi Afsaneh,
    Thank you for the purchase.

    Are you using this in Gravity Forms Integration plugin? Can you please describe this in more details and describe me where do you need this?

  •   Afsaneh replied privately
  • [deleted] replied

    Hi Afsaneh,

    What is written in your database, it doesn't have any relation with wpDataTables plugin or Gravity Forms integration for wpDataTables add-on.

    Entries in the table from database depends on what your users enter in the form. When they write "Cédric" in the form input, that will be saved in the database table.

    Probably you can write some MySQL query to replace all "é" characters with capital "E" character.

  • Afsaneh replied

    Thank you Milos, you can close this ticket, I found a solution with php function..

  • [deleted] replied

    Hi Afsaneh,

    I am glad that you have found the solution. If you have any more question don't hesitate to open a new ticket. We will be glad to help you.

    We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!