Important: This page is using cookies (cookies). Using this website without turning off cookies in browser, means that you agree for using it.
Buy Now! Features Downloads

Earn with us!

If you would like to start earning money with vBET join to Affiliate Program.
Results 1 to 6 of 6

Thread: Utf8_general_ci recommended over Utf8_bin?

  1. #1
    Senior Member
    Join Date
    Oct 2009
    Posts
    142

    Exclamation Utf8_general_ci recommended over Utf8_bin?

    Isn't the utf8_general_ci recommended because

    utf8_bin: compare strings by the binary value of each character in the string

    utf8_general_ci: compare strings using general language rules and using case-insensitive comparisons

    On you next version can you add an option that doesn't convert the db table charset?

  2. #2
    Michał Podbielski (vBET Staff) vBET's Avatar
    Join Date
    Oct 2009
    Posts
    3,037

    Default

    For vBET cache tables we choosed utf8_bin comparator, because we believe this is faster than utf8_general_ci. It is simpler - no rule just compare bytes, so it should be faster that any other comparation based on additional rules (not tested - just based on out logic).
    Also we cannot use use utf8_general_ci, because it is canse insensitive, and we need exact matches in cache.

    Please note that we do not change anything in vB model, so I do not exactly understand why you are asking about not converting db table charset... We do not convert anything in DB. vBET creates its own tables for cache and do not touch existing ones - nothing is converted there...

  3. #3
    Senior Member
    Join Date
    Oct 2009
    Posts
    142

    Default

    It's usually a good idea to keep the same charset for the entire database instead of having 2 different because some extra work(query) is involved when communicating between each other no?

  4. #4
    Michał Podbielski (vBET Staff) vBET's Avatar
    Join Date
    Oct 2009
    Posts
    3,037

    Default

    There is no any communication between vBET cache tables and rest of database schema.

  5. #5
    Senior Member
    Join Date
    Oct 2009
    Posts
    142

    Default

    I didn't mean to say between vbet and vbulletin I mean't for the search engines

  6. #6
    Michał Podbielski (vBET Staff) vBET's Avatar
    Join Date
    Oct 2009
    Posts
    3,037

    Default

    Search engines do not see your database.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •