Snippets-logo-small
  • TYPO3 Typoscript
  • TYPO3 TSConfig
  • TYPO3 Install Tool
  • TYPO3 allg
  • Git
  • Javascript - JQuery
  • Unix
  • css
  • regular expressions
  • php
  • SQL
  • Ruby on Rails
  • Replace Umlaute / Sonderzeichen

Replace Umlaute / Sonderzeichen

  • Für TYPO3 z.b. 

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    
    UPDATE tt_content SET 
    bodytext          = REPLACE(bodytext, '’', '’'),
    bodytext          = REPLACE(bodytext, '©', '©'),
    bodytext          = REPLACE(bodytext, '–', '–'),
    bodytext          = REPLACE(bodytext, '
', ' '),      
    bodytext          = REPLACE(bodytext, '“', '“'),
    bodytext          = REPLACE(bodytext, 'ß', 'ß'),   
    bodytext          = REPLACE(bodytext, 'Ü', 'Ü'),  
    bodytext          = REPLACE(bodytext, 'ü', 'ü'),
    bodytext          = REPLACE(bodytext, 'ä', 'ä'),
    bodytext          = REPLACE(bodytext, 'Ä', 'Ä'),
    bodytext          = REPLACE(bodytext, 'Ö', 'Ö'),
    bodytext          = REPLACE(bodytext, 'ö', 'ö'),
    bodytext          = REPLACE(bodytext, 'á', 'á'),
    bodytext          = REPLACE(bodytext, 'ó', 'ó'),
    bodytext          = REPLACE(bodytext, 'é', 'é'),
    bodytext          = REPLACE(bodytext, 'Ã-', 'í'), 
    bodytext          = REPLACE(bodytext, '€', '€'),
    bodytext          = REPLACE(bodytext, 'ž', 'ž'),  
    bodytext          = REPLACE(bodytext, '…', '…'),   
    bodytext          = REPLACE(bodytext, '‘', '‘'),
    imagecaption      = REPLACE(imagecaption, '’', '’'),
    imagecaption      = REPLACE(imagecaption, '©', '©'),
    imagecaption      = REPLACE(imagecaption, '–', '–'),
    imagecaption      = REPLACE(imagecaption, '
', ' '),      
    imagecaption      = REPLACE(imagecaption, '“', '“'), 
    imagecaption      = REPLACE(imagecaption, 'ß', 'ß'),   
    imagecaption      = REPLACE(imagecaption, 'Ü', 'Ü'),  
    imagecaption      = REPLACE(imagecaption, 'ü', 'ü'),
    imagecaption      = REPLACE(imagecaption, 'ä', 'ä'),
    imagecaption      = REPLACE(imagecaption, 'Ä', 'Ä'),
    imagecaption      = REPLACE(imagecaption, 'Ö', 'Ö'),
    imagecaption      = REPLACE(imagecaption, 'ö', 'ö'),
    imagecaption      = REPLACE(imagecaption, 'á', 'á'),
    imagecaption      = REPLACE(imagecaption, 'ó', 'ó'),
    imagecaption      = REPLACE(imagecaption, 'é', 'é'),
    imagecaption      = REPLACE(imagecaption, 'Ã-', 'í'), 
    imagecaption      = REPLACE(imagecaption, '€', '€'),
    imagecaption      = REPLACE(imagecaption, 'ž', 'ž'),  
    imagecaption      = REPLACE(imagecaption, '…', '…'),   
    imagecaption      = REPLACE(imagecaption, '‘', '‘'); 
    by stefan
This site is made by tan3