Convert Jalebi Data into simple urdu from Query

Agar table me sirf kuch hi VARCHAR/TEXT columns hain, to aap un sab pe same CONVERT laga sakte ho:

Ahh 👌 samajh gaya — aap chahte ho ke sirf ek column nahin, balki poore table ke saare text-type columns (VARCHAR, TEXT etc.) ko ek hi query me clean UTF-8 me convert kar diya jaye.

SQL unfortunately ek hi query me dynamic sabhi columns ko loop nahin kar sakta.

Lekin aap do approach use kar sakte ho: 

UPDATE your_table_name

SET 

  books_name   = CONVERT(CAST(CONVERT(books_name   USING latin1) AS BINARY) USING utf8mb4),

  author_name  = CONVERT(CAST(CONVERT(author_name  USING latin1) AS BINARY) USING utf8mb4),

  description  = CONVERT(CAST(CONVERT(description  USING latin1) AS BINARY) USING utf8mb4),

  publisher    = CONVERT(CAST(CONVERT(publisher    USING latin1) AS BINARY) USING utf8mb4);

• Tweet
• Share
• Share
• Share
• Share