SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot kosh's Avatar
    Join Date
    Aug 2000
    Location
    USA
    Posts
    122
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mysql table in utf8 but database in latin1?

    I have a MySQL 5.0.22 database. It's delivering garbled text (the traditional latin1 vs. utf8 issue). I converted the fields in a particular table to blobs, then used "ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8" to convert each field to utf8. The problem? The text still appears garbled.

    When I issue the status command (/s) I see this:

    mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (x86_64) using readline 5.0

    Connection id: 441212
    ...
    Protocol version: 10
    Connection: Localhost via UNIX socket
    Server characterset: latin1
    Db characterset: latin1
    Client characterset: latin1
    Conn. characterset: latin1

    My concern is that everything is still latin1. Wouldn't that force conversions of the characters in my new utf8 table? Or is it something else? And how would I configure a single table to work with utf8 while everything else remains latin1?
    Outshine - geek blog & free phpBB mods
    Publisher Database - tools & forums for writers
    What Do Women Want? - dating advice for men, from women

  2. #2
    SitePoint Enthusiast aksival's Avatar
    Join Date
    Nov 2009
    Location
    Central Florida, USA
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I usually use phpMyAdmin to set the database and each individual table to UTF-8. This has always confused me, especially since the default is usually Latin.

    I'm not a command line buff when it comes to MySQL, but I'm guessing the command isn't correct or there is some kind or restriction preventing you from updating the database tables. Have you tried making the changes in phpMyAdmin or MySQL Administrator?


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
  •