Announcement

Collapse
No announcement yet.

default UTF-8

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    commented on 's reply
    Code:
    UTF-8 encoded sample plain-text file
    ‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
    
    Markus Kuhn [ˈmaʳkʊs kuːn] <[email protected]> — 1999-08-20
    
    
    The ASCII compatible UTF-8 encoding of ISO 10646 and Unicode
    plain-text files is defined in RFC 2279 and in ISO 10646-1 Annex R.
    
    
    Using Unicode/UTF-8, you can write in emails and source code things such as
    
    Mathematics and Sciences:
    
      ∮ E⋅da = Q,  n → ∞, ∑ f(i) = ∏ g(i), ∀x∈ℝ: ⌈x⌉ = −⌊−x⌋, α ∧ ¬β = ¬(¬α ∨ β),
    
      ℕ ⊆ ℕ₀ ⊂ ℤ ⊂ ℚ ⊂ ℝ ⊂ ℂ, ⊥ < a ≠ b ≡ c ≤ d ≪ ⊤ ⇒ (A ⇔ B),
    
      2H₂ + O₂ ⇌ 2H₂O, R = 4.7 kΩ, ⌀ 200 mm
    
    Linguistics and dictionaries:
    
      ði ıntəˈnæʃənəl fəˈnɛtık əsoʊsiˈeıʃn
      Y [ˈʏpsilɔn], Yen [jɛn], Yoga [ˈjoːgɑ]
    
    APL:
    
      ((V⍳V)=⍳⍴V)/V←,V    ⌷←⍳→⍴∆∇⊃‾⍎⍕⌈
    
    Nicer typography in plain text files:
    
      ╔══════════════════════════════════════════╗
      ║                                          ║
      ║   • ‘single’ and “double” quotes         ║
      ║                                          ║
      ║   • Curly apostrophes: “We’ve been here” ║
      ║                                          ║
      ║   • Latin-1 apostrophe and accents: '´`  ║
      ║                                          ║
      ║   • ‚deutsche‘ „Anführungszeichen“       ║
      ║                                          ║
      ║   • †, ‡, ‰, •, 3–4, —, −5/+5, ™, …      ║
      ║                                          ║
      ║   • ASCII safety test: 1lI|, 0OD, 8B     ║
      ║                      ╭─────────╮         ║
      ║   • the euro symbol: │ 14.95 € │         ║
      ║                      ╰─────────╯         ║
      ╚══════════════════════════════════════════╝
    
    Greek (in Polytonic):
    
      The Greek anthem:
    
      Σὲ γνωρίζω ἀπὸ τὴν κόψη
      τοῦ σπαθιοῦ τὴν τρομερή,
      σὲ γνωρίζω ἀπὸ τὴν ὄψη
      ποὺ μὲ βία μετράει τὴ γῆ.
    
      ᾿Απ᾿ τὰ κόκκαλα βγαλμένη
      τῶν ῾Ελλήνων τὰ ἱερά
      καὶ σὰν πρῶτα ἀνδρειωμένη
      χαῖρε, ὦ χαῖρε, ᾿Ελευθεριά!
    
      From a speech of Demosthenes in the 4th century BC:
    
      Οὐχὶ ταὐτὰ παρίσταταί μοι γιγνώσκειν, ὦ ἄνδρες ᾿Αθηναῖοι,
      ὅταν τ᾿ εἰς τὰ πράγματα ἀποβλέψω καὶ ὅταν πρὸς τοὺς
      λόγους οὓς ἀκούω· τοὺς μὲν γὰρ λόγους περὶ τοῦ
      τιμωρήσασθαι Φίλιππον ὁρῶ γιγνομένους, τὰ δὲ πράγματ᾿
      εἰς τοῦτο προήκοντα,  ὥσθ᾿ ὅπως μὴ πεισόμεθ᾿ αὐτοὶ
      πρότερον κακῶς σκέψασθαι δέον. οὐδέν οὖν ἄλλο μοι δοκοῦσιν
      οἱ τὰ τοιαῦτα λέγοντες ἢ τὴν ὑπόθεσιν, περὶ ἧς βουλεύεσθαι,
      οὐχὶ τὴν οὖσαν παριστάντες ὑμῖν ἁμαρτάνειν. ἐγὼ δέ, ὅτι μέν
      ποτ᾿ ἐξῆν τῇ πόλει καὶ τὰ αὑτῆς ἔχειν ἀσφαλῶς καὶ Φίλιππον
      τιμωρήσασθαι, καὶ μάλ᾿ ἀκριβῶς οἶδα· ἐπ᾿ ἐμοῦ γάρ, οὐ πάλαι
      γέγονεν ταῦτ᾿ ἀμφότερα· νῦν μέντοι πέπεισμαι τοῦθ᾿ ἱκανὸν
      προλαβεῖν ἡμῖν εἶναι τὴν πρώτην, ὅπως τοὺς συμμάχους
      σώσομεν. ἐὰν γὰρ τοῦτο βεβαίως ὑπάρξῃ, τότε καὶ περὶ τοῦ
      τίνα τιμωρήσεταί τις καὶ ὃν τρόπον ἐξέσται σκοπεῖν· πρὶν δὲ
      τὴν ἀρχὴν ὀρθῶς ὑποθέσθαι, μάταιον ἡγοῦμαι περὶ τῆς
      τελευτῆς ὁντινοῦν ποιεῖσθαι λόγον.
    
      Δημοσθένους, Γ´ ᾿Ολυνθιακὸς
    
    Georgian:
    
      From a Unicode conference invitation:
    
      გთხოვთ ახლავე გაიაროთ რეგისტრაცია Unicode-ის მეათე საერთაშორისო
      კონფერენციაზე დასასწრებად, რომელიც გაიმართება 10-12 მარტს,
      ქ. მაინცში, გერმანიაში. კონფერენცია შეჰკრებს ერთად მსოფლიოს
      ექსპერტებს ისეთ დარგებში როგორიცაა ინტერნეტი და Unicode-ი,
      ინტერნაციონალიზაცია და ლოკალიზაცია, Unicode-ის გამოყენება
      ოპერაციულ სისტემებსა, და გამოყენებით პროგრამებში, შრიფტებში,
      ტექსტების დამუშავებასა და მრავალენოვან კომპიუტერულ სისტემებში.
    
    Russian:
    
      From a Unicode conference invitation:
    
      Зарегистрируйтесь сейчас на Десятую Международную Конференцию по
      Unicode, которая состоится 10-12 марта 1997 года в Майнце в Германии.
      Конференция соберет широкий круг экспертов по  вопросам глобального
      Интернета и Unicode, локализации и интернационализации, воплощению и
      применению Unicode в различных операционных системах и программных
      приложениях, шрифтах, верстке и многоязычных компьютерных системах.
    
    Thai (UCS Level 2):
    
      Excerpt from a poetry on The Romance of The Three Kingdoms (a Chinese
      classic 'San Gua'):
    
      [----------------------------|------------------------]
        ๏ แผ่นดินฮั่นเสื่อมโทรมแสนสังเวช  พระปกเกศกองบู๊กู้ขึ้นใหม่
      สิบสองกษัตริย์ก่อนหน้าแลถัดไป       สององค์ไซร้โง่เขลาเบาปัญญา
        ทรงนับถือขันทีเป็นที่พึ่ง           บ้านเมืองจึงวิปริตเป็นนักหนา
      โฮจิ๋นเรียกทัพทั่วหัวเมืองมา         หมายจะฆ่ามดชั่วตัวสำคัญ
        เหมือนขับไสไล่เสือจากเคหา      รับหมาป่าเข้ามาเลยอาสัญ
      ฝ่ายอ้องอุ้นยุแยกให้แตกกัน          ใช้สาวนั้นเป็นชนวนชื่นชวนใจ
        พลันลิฉุยกุยกีกลับก่อเหตุ          ช่างอาเพศจริงหนาฟ้าร้องไห้
      ต้องรบราฆ่าฟันจนบรรลัย           ฤๅหาใครค้ำชูกู้บรรลังก์ ฯ
    
      (The above is a two-column text. If combining characters are handled
      correctly, the lines of the second column should be aligned with the
      | character above.)
    
    Ethiopian:
    
      Proverbs in the Amharic language:
    
      ሰማይ አይታረስ ንጉሥ አይከሰስ።
      ብላ ካለኝ እንደአባቴ በቆመጠኝ።
      ጌጥ ያለቤቱ ቁምጥና ነው።
      ደሀ በሕልሙ ቅቤ ባይጠጣ ንጣት በገደለው።
      የአፍ ወለምታ በቅቤ አይታሽም።
      አይጥ በበላ ዳዋ ተመታ።
      ሲተረጉሙ ይደረግሙ።
      ቀስ በቀስ፥ ዕንቁላል በእግሩ ይሄዳል።
      ድር ቢያብር አንበሳ ያስር።
      ሰው እንደቤቱ እንጅ እንደ ጉረቤቱ አይተዳደርም።
      እግዜር የከፈተውን ጉሮሮ ሳይዘጋው አይድርም።
      የጎረቤት ሌባ፥ ቢያዩት ይስቅ ባያዩት ያጠልቅ።
      ሥራ ከመፍታት ልጄን ላፋታት።
      ዓባይ ማደሪያ የለው፥ ግንድ ይዞ ይዞራል።
      የእስላም አገሩ መካ የአሞራ አገሩ ዋርካ።
      ተንጋሎ ቢተፉ ተመልሶ ባፉ።
      ወዳጅህ ማር ቢሆን ጨርስህ አትላሰው።
      እግርህን በፍራሽህ ልክ ዘርጋ።
    
    Runes:
    
      ᚻᛖ ᚳᚹᚫᚦ ᚦᚫᛏ ᚻᛖ ᛒᚢᛞᛖ ᚩᚾ ᚦᚫᛗ ᛚᚪᚾᛞᛖ ᚾᚩᚱᚦᚹᛖᚪᚱᛞᚢᛗ ᚹᛁᚦ ᚦᚪ ᚹᛖᛥᚫ
    
      (Old English, which transcribed into Latin reads 'He cwaeth that he
      bude thaem lande northweardum with tha Westsae.' and means 'He said
      that he lived in the northern land near the Western Sea.')
    
    Braille:
    
      ⡌⠁⠧⠑ ⠼⠁⠒  ⡍⠜⠇⠑⠹⠰⠎ ⡣⠕⠌
    
      ⡍⠜⠇⠑⠹ ⠺⠁⠎ ⠙⠑⠁⠙⠒ ⠞⠕ ⠃⠑⠛⠔ ⠺⠊⠹⠲ ⡹⠻⠑ ⠊⠎ ⠝⠕ ⠙⠳⠃⠞
      ⠱⠁⠞⠑⠧⠻ ⠁⠃⠳⠞ ⠹⠁⠞⠲ ⡹⠑ ⠗⠑⠛⠊⠌⠻ ⠕⠋ ⠙⠊⠎ ⠃⠥⠗⠊⠁⠇ ⠺⠁⠎
      ⠎⠊⠛⠝⠫ ⠃⠹ ⠹⠑ ⠊⠇⠻⠛⠹⠍⠁⠝⠂ ⠹⠑ ⠊⠇⠻⠅⠂ ⠹⠑ ⠥⠝⠙⠻⠞⠁⠅⠻⠂
      ⠁⠝⠙ ⠹⠑ ⠡⠊⠑⠋ ⠍⠳⠗⠝⠻⠲ ⡎⠊⠗⠕⠕⠛⠑ ⠎⠊⠛⠝⠫ ⠊⠞⠲ ⡁⠝⠙
      ⡎⠊⠗⠕⠕⠛⠑⠰⠎ ⠝⠁⠍⠑ ⠺⠁⠎ ⠛⠕⠕⠙ ⠥⠏⠕⠝ ⠰⡡⠁⠝⠛⠑⠂ ⠋⠕⠗ ⠁⠝⠹⠹⠔⠛ ⠙⠑
      ⠡⠕⠎⠑ ⠞⠕ ⠏⠥⠞ ⠙⠊⠎ ⠙⠁⠝⠙ ⠞⠕⠲
    
      ⡕⠇⠙ ⡍⠜⠇⠑⠹ ⠺⠁⠎ ⠁⠎ ⠙⠑⠁⠙ ⠁⠎ ⠁ ⠙⠕⠕⠗⠤⠝⠁⠊⠇⠲
    
      ⡍⠔⠙⠖ ⡊ ⠙⠕⠝⠰⠞ ⠍⠑⠁⠝ ⠞⠕ ⠎⠁⠹ ⠹⠁⠞ ⡊ ⠅⠝⠪⠂ ⠕⠋ ⠍⠹
      ⠪⠝ ⠅⠝⠪⠇⠫⠛⠑⠂ ⠱⠁⠞ ⠹⠻⠑ ⠊⠎ ⠏⠜⠞⠊⠊⠥⠇⠜⠇⠹ ⠙⠑⠁⠙ ⠁⠃⠳⠞
      ⠁ ⠙⠕⠕⠗⠤⠝⠁⠊⠇⠲ ⡊ ⠍⠊⠣⠞ ⠙⠁⠧⠑ ⠃⠑⠲ ⠔⠊⠇⠔⠫⠂ ⠍⠹⠎⠑⠇⠋⠂ ⠞⠕
      ⠗⠑⠛⠜⠙ ⠁ ⠊⠕⠋⠋⠔⠤⠝⠁⠊⠇ ⠁⠎ ⠹⠑ ⠙⠑⠁⠙⠑⠌ ⠏⠊⠑⠊⠑ ⠕⠋ ⠊⠗⠕⠝⠍⠕⠝⠛⠻⠹
      ⠔ ⠹⠑ ⠞⠗⠁⠙⠑⠲ ⡃⠥⠞ ⠹⠑ ⠺⠊⠎⠙⠕⠍ ⠕⠋ ⠳⠗ ⠁⠝⠊⠑⠌⠕⠗⠎
      ⠊⠎ ⠔ ⠹⠑ ⠎⠊⠍⠊⠇⠑⠆ ⠁⠝⠙ ⠍⠹ ⠥⠝⠙⠁⠇⠇⠪⠫ ⠙⠁⠝⠙⠎
      ⠩⠁⠇⠇ ⠝⠕⠞ ⠙⠊⠌⠥⠗⠃ ⠊⠞⠂ ⠕⠗ ⠹⠑ ⡊⠳⠝⠞⠗⠹⠰⠎ ⠙⠕⠝⠑ ⠋⠕⠗⠲ ⡹⠳
      ⠺⠊⠇⠇ ⠹⠻⠑⠋⠕⠗⠑ ⠏⠻⠍⠊⠞ ⠍⠑ ⠞⠕ ⠗⠑⠏⠑⠁⠞⠂ ⠑⠍⠏⠙⠁⠞⠊⠊⠁⠇⠇⠹⠂ ⠹⠁⠞
      ⡍⠜⠇⠑⠹ ⠺⠁⠎ ⠁⠎ ⠙⠑⠁⠙ ⠁⠎ ⠁ ⠙⠕⠕⠗⠤⠝⠁⠊⠇⠲
    
      (The first couple of paragraphs of "A Christmas Carol" by Dickens)
    
    Compact font selection example text:
    
      ABCDEFGHIJKLMNOPQRSTUVWXYZ /0123456789
      abcdefghijklmnopqrstuvwxyz £©µÀÆÖÞßéöÿ
      –—‘“”„†•…‰™œŠŸž€ ΑΒΓΔΩαβγδω АБВГДабвгд
      ∀∂∈ℝ∧∪≡∞ ↑↗↨↻⇣ ┐┼╔╘░►☺♀ fi�⑀₂ἠḂӥẄɐː⍎אԱა
    
    Greetings in various languages:
    
      Hello world, Καλημέρα κόσμε, コンニチハ
    
    Box drawing alignment tests:                                          █
                                                                          ▉
      ╔══╦══╗  ┌──┬──┐  ╭──┬──╮  ╭──┬──╮  ┏━━┳━━┓  ┎┒┏┑   ╷  ╻ ┏┯┓ ┌┰┐    ▊ ╱╲╱╲╳╳╳
      ║┌─╨─┐║  │╔═╧═╗│  │╒═╪═╕│  │╓─╁─╖│  ┃┌─╂─┐┃  ┗╃╄┙  ╶┼╴╺╋╸┠┼┨ ┝╋┥    ▋ ╲╱╲╱╳╳╳
      ║│╲ ╱│║  │║   ║│  ││ │ ││  │║ ┃ ║│  ┃│ ╿ │┃  ┍╅╆┓   ╵  ╹ ┗┷┛ └┸┘    ▌ ╱╲╱╲╳╳╳
      ╠╡ ╳ ╞╣  ├╢   ╟┤  ├┼─┼─┼┤  ├╫─╂─╫┤  ┣┿╾┼╼┿┫  ┕┛┖┚     ┌┄┄┐ ╎ ┏┅┅┓ ┋ ▍ ╲╱╲╱╳╳╳
      ║│╱ ╲│║  │║   ║│  ││ │ ││  │║ ┃ ║│  ┃│ ╽ │┃  ░░▒▒▓▓██ ┊  ┆ ╎ ╏  ┇ ┋ ▎
      ║└─╥─┘║  │╚═╤═╝│  │╘═╪═╛│  │╙─╀─╜│  ┃└─╂─┘┃  ░░▒▒▓▓██ ┊  ┆ ╎ ╏  ┇ ┋ ▏
      ╚══╩══╝  └──┴──┘  ╰──┴──╯  ╰──┴──╯  ┗━━┻━━┛           └╌╌┘ ╎ ┗╍╍┛ ┋  ▁▂▃▄▅▆▇█

  • Wayne Luke
    replied
    If you're using English then your locale should be something like en_us.UTF-8 for US English or en_uk.UTF-8 for UK English. The HTML Character Set and Locale tell the browser how to display characters.

    If you use something like ISO-8859-1 for the HTML character set, then you're restricting display to basically ASCII and a few other characters. With a UTF-8 character set, the browser will use the full breadth of the font available.

    Leave a comment:


  • NLP-er
    replied
    Locale is not set at all in Language Manager. But should I really set there value UTF-8 or en.UTF-8 (case sensitive?)? Before or after running db scripts (I used backup to restore before scripts). Is it even related to characterset issues? Because if not let leave it for moment and focus on main issue.

    I do not want to make new installation, but upgrade from vB4. If characters were stored as HTML entity so why they do not work anymore? They are still the same, why the problem? How to solve it? Cannot they stay as HTML entity? Any solution which will work when db scripts are not enought?

    Leave a comment:


  • Wayne Luke
    replied
    A default vBulletin 4.X did not actually use UTF-8 in any way shape or form. If the character was not within the standard ASCII character set, it was converted and stored as its HTML Entity. It was not stored in UTF-8 or processed as UTF-8 at any time.

    The MySQL Connection has nothing to do with how data is stored or processed within vBulletin. It tells MySQL how to accept data. Even with UTF-8, we don't actually know what character is what? Why? Because UTF-8 stores characters in 2-4 bytes on MySQL. This is why MySQL actually recommends UTF8MB4 and that is what vBulletin 5 has been developed to use these days. With UTF8MB4, every character takes 4 bytes.

    vBulletin will create tables with the default collation of your database. If your database's default collation is latin1_swedish_ci (like 99% of installations before MySQL 8) than that is what vBulletin will use. We assume you know more about your database than we do. You would have multiple collations if you changed the collation on some tables and did not update the default collation. The only exception to this rule is on New Installations of vBulletin 5.x will force the UTF8MB4 character set and corresponding collation. On MySQL 5.7, this should be something like utf8mb4_general_ci. On MySQL 8.0 and higher it should be utf8mb4_900_ai_ci.

    Language settings for vBulletin are accessed in the AdminCP under Languages → Language Manager. The only HTML Character Set that should be used in 2022 is UTF-8. The locale should match the actual language and be the UTF-8 variant. If you do not specify the locale the text used in dates and times will not match that language.

    It is always complicated converting older databases. They often have a lot of cruft and there is no way to guarantee they haven't been manipulated by external software like plugins.

    Leave a comment:


  • NLP-er
    replied
    UTF-8 was used in vB4 so I don't understand why it is broken after upgrade.UTF-8 was set for mysql connection. It was set (and still is) in 'HTML Character Set' for Language Manager (English(US)). It was set for most of vBulletin tables (utf8_general_ci) for some it is set latin1_swedish_ci (have no idea why vBulletin created tables with 2 different encodings).

    You wrote to make sure my languages are using UTF-8 - in my knowdlege they are (mysql connection setting and language manager setting). Where I suppose to check what locale are used?

    Leave a comment:


  • Wayne Luke
    replied
    Make sure your languages are using a UTF-8 character set and a UTF-8 Locale. The Locale will need to be installed at the server level if not available already.

    Most UTF-8 locales simply have .UTF-8 added to the locale for the language.

    Leave a comment:


  • NLP-er
    replied
    I tried 3 times with different combinations. After db scripts german signs are corrected, but not polish or vietmamise and probably lot more. What to do?

    Leave a comment:


  • NLP-er
    replied
    Thx. Unfortunatelly after using db scripts some characters are still broken. Will rebuild from backup and try again with point 9 too.

    Leave a comment:


  • Wayne Luke
    replied
    Also - where can I drop vB cache? I see that aster changes one page is still bad, but other is OK. Don't know is it still issue with encoding or some cache.
    Drop is the wrong word. You mean truncate or delete the contents.

    In the AdminCP go to Maintenance → Delete System Cache. Same place as in vBulletin 4.X.

    Leave a comment:


  • Wayne Luke
    replied
    Originally posted by NLP-er View Post
    BTW - why cache shoudn't be don in MyISAM? Arent those best for lot of reads and smal ammount of writes saving on not handling transactions?
    MyISAM isn't really best for anything because every access (read or write) locks the entire table. This causes queries to be backlogged. In the long run, developers end up creating inefficient long queries but use less of queries overall because of this. However database access time is still increased and services like PHP are just waiting for results.

    INNODB promotes using a lot of efficient small queries. It allows reads and writes on the same table at the same time, as long as they aren't accessing the exact same row. These small queries run quicker and are easier to optimize. This gives MySQL more time to run queries and there is less of a backlog on most systems.

    There are only three tables in vBulletin 5 that should by MyISAM. language, phrase, and userfield. The reason for this is because there is absolutely no way on knowing the actual sizes of these tables and INNODB tables are limited to a row length of 8192 bytes on most MySQL installations. MySQL 8 handles this limitation better by moving more char and varchar fields to the BLOB space and just using 4 bytes for each to hold the addresses.

    However, the current minimum version of MySQL supported is 5.6. So the software must be developed within its limitations. Soon this version will be increased to 5.7 but I suspect that will cause problems as many hosts don't upgrade their database servers as often as they should. I understand this as it is a lengthy process and will require sites to be down. Ideally, everyone should be using MySQL 8.X but I don't foresee that happening this decade. Especially since some people think MariaDB has a "better" open source paradigm when it is just a fork of MySQL.

    The fact that we're still talking about the benefits of INNODB over MyISAM in 2022 shows how slow people are to update. We've been recommending using INNODB for the majority of vBulletin tables since vBulletin 4 was released in 2009.

    Leave a comment:


  • NLP-er
    replied
    Point 10 - by additional tables I mean what I wrote: "configuraition allows to add those" - so tables added in script configuration. More preciselly in $extraVbTables = array('tablename');

    BTW - why cache shoudn't be don in MyISAM? Arent those best for lot of reads and smal ammount of writes saving on not handling transactions?

    Also - where can I drop vB cache? I see that aster changes one page is still bad, but other is OK. Don't know is it still issue with encoding or some cache.
    Last edited by NLP-er; Thu 3 Feb '22, 7:23am.

    Leave a comment:


  • Wayne Luke
    replied
    Point 8 - the myisamfix script in the sequence will update tables to innodb. As necessary.
    Point 9 - Have no idea how the translation plugin works. I would assume it works best with UTF-8 data though since the is the international standard for translations.
    Point 10 - vBulletin's cache tables should never be MyISAM. This is the single largest cause of performance problems with modern databases. Otherwise, I don't know what you mean about additional tables. The scripts are designed to work with vBulletin 5 tables. Changes to any other tables are not tested or evaluated.

    Leave a comment:


  • NLP-er
    replied
    Questoins about scripts - relating to instructions from site you gave:
    Point 8 - and what if some tables are MyIsam and some InnoDB? Should I use the script? For sxample 'contentpriority' is MyIsam, but 'contenttype' is InnoDB.
    Point 9 - and what if U use English and not English? (tranlsation plugin was and will be used after succesfup update). Should I use the script? I suppose not, but not sure.
    Point 10 - can I use it also for additional tables (configuraition allows to add those) which in puspose are still MyIsam (cache tambles)?
    Last edited by NLP-er; Wed 2 Feb '22, 2:09pm.

    Leave a comment:


  • NLP-er
    replied
    Thanks. I will do full backup and use scripts. Hope this will help. Will let you know.

    Leave a comment:


  • Wayne Luke
    replied
    The option is outdated and can cause problems with modern servers. It was put into place for MySQL 4.1. Today, all versions of MySQL supported use UTF-8 to store their data by default. However, character sets (i.e. Latin1) and collations (latin1_swedish_ci) can break UTF-8 character display. vBulletin 4.X didn't understand UTF-8 at all. It would update characters to their HTML Entities. vBulletin 5 does understand UTF-8 so will not convert these characters to their HTML Entities. This is a side effect of trying to apply a decade of software changes at once.

    You should convert your database to UTF8MB4 for the best results. We provide scripts for this. Please look at the Database Tools article for information on updating your site to UTFMB4. This will provide the best results going forward and enable functionality like UTF-8 combination characters. These combination characters are necessary to support the 1000+ emoji that are available on most devices these days.

    Leave a comment:

Related Topics

Collapse

Working...
X