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!