SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict crabby80's Avatar
    Join Date
    May 2007
    Posts
    387
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    need to change collation_database variable

    Hi guys

    How do I change the collation_database varible from latin1_swedish_ci to utf8_general_ci?

    I've already managed to change the collation_connection and collation_server

    Any help would be much appreciated.

    Thanks

    Crabby

  2. #2
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you checked out the documentation?

    http://dev.mysql.com/doc/refman/5.0/...onnection.html

    Also, use phpMyAdmin for your sanity unless you prefer the command line:

    http://www.phpmyadmin.net/
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  3. #3
    SitePoint Addict crabby80's Avatar
    Join Date
    May 2007
    Posts
    387
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Thanks for your reply

    ok I'm really running out of ideas now

    I've changed the MySQL server so that the charset is

    PHP Code:
    collation_connection utf8_general_ci
    collation_server utf8_general_ci 
    I've re-created the database so this variable is now set

    PHP Code:
    collation_database utf8_general_ci 
    I've changed the fields in my table to utf8_general_ci collation

    And I'm still getting odd chars particulary (for a mid point) when insert data?

    What else can I try??


Bookmarks

Posting Permissions

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