Thread: Collation

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2013
    Posts
    8
    Rep Power
    0

    Collation


    Perhaps this is more of a "general" DB question, but I'm using MySQL...

    How does one determine the corrct collation for a particular DB project? What exactly *is* collation?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,785
    Rep Power
    348
    So if you are using MySQL, why are you posting in the Microsoft SQL Server forum?

    The MySQL manual explains what a collation is: MySQL :: MySQL 5.5 Reference Manual :: 10.4 Adding a Collation to a Character Set

    Originally Posted by The Fine Manual
    A collation is a set of rules that defines how to compare and sort character strings.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,209
    Rep Power
    4279
    thread moved to mysql forum
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2013
    Posts
    8
    Rep Power
    0
    Originally Posted by shammat
    So if you are using MySQL, why are you posting in the Microsoft SQL Server forum?
    Obviously an error.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2013
    Posts
    8
    Rep Power
    0
    Originally Posted by shammat
    So if you are using MySQL, why are you posting in the Microsoft SQL Server forum?

    The MySQL manual explains what a collation is: MySQL :: MySQL 5.5 Reference Manual :: 10.4 Adding a Collation to a Character Set
    Also, I know how to search the Internet, and read manuals. I think it's faily obvious that I'm seeking responses based on personal experience that might enhance the information found in THM.

    I must say, I've never understood people that will spend their own valuble time not answering a question, and instead pontificating some admonation.

    - JS
  10. #6
  11. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,209
    Rep Power
    4279
    Originally Posted by Johnny Squeaky
    ...and instead pontificating some admonation.
    at the point shammat posted, it most certainly was not clear that you were aware of the mysql manual

    now that you admit you've read it, what further specific question do you have? more specific than a "general" question, that is
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,785
    Rep Power
    348
    Originally Posted by Johnny Squeaky
    Also, I know how to search the Internet, and read manuals.
    Sorry that was absolutely not clear from your post. Your question neither mentioned any research effort nor that you read the manual. And as you posted in the SQL Server forum instead of the MySQL forum chances were even higher that you didn't look at the manual

    Originally Posted by Johnny Squeaky
    I think it's faily obvious that I'm seeking responses based on personal experience that might enhance the information found in THM
    No, not obvious at all (where in your question do you say "I'm seeking responses based on personal experience"?)

    • You don't explain why you ask.
    • You don't explain what exactly you are trying to do.
    • You don't explain what kind of queries you are running for which you suspect the collation to make a difference.
    • You don't explain if you have any problems where you suspect the wrong collation to be the reason.
    • You don't explain what your understanding of a collation is and how you used it so far.
    • You don't mention that you went through the manual and searched the internet and didn't find anything
    • You don't tell us what the result of your search is and what you think a collation is or should be used


    With all that information being absent, the best thing to do was to answer with a short and concise explanation on what a collation is.

    I must say, I've never understood people that will spend their own valuble time not answering a question, and instead pontificating some admonation.
    I must say I never understood people that ask question without providing background on what they want to achieve, what their problem is and what they have tried so far.
    How To Ask Questions The Smart Way
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

IMN logo majestic logo threadwatch logo seochat tools logo