Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. MySQL
  4. what the work of collate Latin1_General_BIN in sql

what the work of collate Latin1_General_BIN in sql

Scheduled Pinned Locked Moved MySQL
databasecom
4 Posts 4 Posters 5 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    Piyush Vardhan Singh
    wrote on last edited by
    #1

    what the work of collate Latin1_General_BIN in sql

    Piyush Vardhan Singh p_vardhan14@rediffmail.com http://holyschoolofvaranasi.blogspot.com http://holytravelsofvaranasi.blogspot.com

    W A C 3 Replies Last reply
    0
    • P Piyush Vardhan Singh

      what the work of collate Latin1_General_BIN in sql

      Piyush Vardhan Singh p_vardhan14@rediffmail.com http://holyschoolofvaranasi.blogspot.com http://holytravelsofvaranasi.blogspot.com

      W Offline
      W Offline
      Wendelius
      wrote on last edited by
      #2

      That's a collation having latin character set and every comparison is done at binary level.

      The need to optimize rises from a bad design.My articles[^]

      1 Reply Last reply
      0
      • P Piyush Vardhan Singh

        what the work of collate Latin1_General_BIN in sql

        Piyush Vardhan Singh p_vardhan14@rediffmail.com http://holyschoolofvaranasi.blogspot.com http://holytravelsofvaranasi.blogspot.com

        A Offline
        A Offline
        Anshumas
        wrote on last edited by
        #3

        It basically sets the reference language of the characters in the field, useful in the event you need to have multiple, or different than that of the default to the database.

        Anshuman Singh

        1 Reply Last reply
        0
        • P Piyush Vardhan Singh

          what the work of collate Latin1_General_BIN in sql

          Piyush Vardhan Singh p_vardhan14@rediffmail.com http://holyschoolofvaranasi.blogspot.com http://holytravelsofvaranasi.blogspot.com

          C Offline
          C Offline
          Cruel Handsome
          wrote on last edited by
          #4

          Sorry, Icould not identify the question correctly

          Sujit Sahu (Cruel Handsome)

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups