{"id":1383,"date":"2020-10-26T13:02:17","date_gmt":"2020-10-26T11:02:17","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1383"},"modified":"2020-10-26T13:02:17","modified_gmt":"2020-10-26T11:02:17","slug":"sql-kasowanie-usmieszkow-z-tresci-maila-wprowadzonego-do-aplikacji-w-jtf-jtf_notes_tl","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1383","title":{"rendered":"SQL – kasowanie u\u015bmieszk\u00f3w z tre\u015bci maila wprowadzonego do aplikacji w jtf.jtf_notes_tl"},"content":{"rendered":"

Je\u017celi u\u017cytkownicy wprowadzaj\u0105 tre\u015b\u0107 mali do aplikacji mo\u017cliwe, \u017ce zostan\u0105 zaimportowane u\u015bmieszki https:\/\/www.w3schools.com\/charsets\/ref_emoji_smileys.asp Tego typu emotiony potrafi\u0105 spowodowa\u0107, \u017ce formatka windykacji zak\u0142adka uwagi nie wy\u015bwietli takich danych. Nowe wersje JAVY radz\u0105 sobie ale jak nie mo\u017cna wgra\u0107 patcha to mo\u017cna zrobi\u0107 update.<\/p>\n

UPDATE jtf.jtf_notes_tl
\nSET
\n notes = regexp_replace(notes, '[’
\n || unistr(’\\F090\\8080′)
\n || ’-’
\n || unistr(’\\DBFF\\DFFF’)
\n || ’]’)
\nWHERE
\n length(notes) <> length(regexp_replace(notes, '[’
\n || unistr(’\\F090\\8080′)
\n || ’-’
\n || unistr(’\\DBFF\\DFFF’)
\n || ’]’))
\n AND language = 'PL’<\/p>\n","protected":false},"excerpt":{"rendered":"

Je\u017celi u\u017cytkownicy wprowadzaj\u0105 tre\u015b\u0107 mali do aplikacji mo\u017cliwe, \u017ce zostan\u0105 zaimportowane u\u015bmieszki https:\/\/www.w3schools.com\/charsets\/ref_emoji_smileys.asp Tego typu emotiony potrafi\u0105 spowodowa\u0107, \u017ce formatka windykacji zak\u0142adka uwagi nie wy\u015bwietli takich danych. Nowe wersje JAVY radz\u0105 sobie ale jak nie mo\u017cna wgra\u0107 patcha to mo\u017cna … Czytaj dalej →<\/span><\/a><\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[186],"tags":[],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1383"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1383"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1383\/revisions"}],"predecessor-version":[{"id":1384,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1383\/revisions\/1384"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}