Forum

Results 1 to 9 of 9
  1. #1
    Join Date
    July 2010
    Location
    Chicago
    Posts
    154

    Why does TeamSpeak/MySQL save Unicode characters as ASCII?

    I converted my TeamSpeak 3 server from SQLite to MySQL and I've noticed some very strange behavior in regards to TeamSpeak saving Unicode characters. For instance, someone joined my server with the following name:

    あっちゃんさん
    But in the clients table, it is saved as:

    ‚っち‚ƒ‚“•‚“
    I've tried every Unicode collation on MySQL, but to no avail. It saves this way no matter what. Is this a bug or does TeamSpeak have to save this way for compatibility with SQLite?
    Last edited by PatPeter; September 3rd, 2013 at 07:10 AM. Reason: Question.

  2. #2
    Join Date
    July 2010
    Location
    Chicago
    Posts
    154
    Can anyone else confirm that this happens to him or her?

  3. #3
    Join Date
    July 2010
    Location
    Chicago
    Posts
    154
    Anyone want to look into their MySQL database?

  4. #4
    Join Date
    July 2010
    Location
    Chicago
    Posts
    154
    According to SELECT * FROM information_schema.SCHEMATA; my database is utf8 / utf8_general_ci for its character set / collation. All of the tables in my database match as well. However, UTF8 characters are still being saved as single-byte characters.

  5. #5
    Join Date
    December 2004
    Location
    RF
    Posts
    3,007

    Question

    Let me guess.
    You used MySQL "root" or equivalent user with SUPER privilege to connect to the database?

  6. #6
    Join Date
    July 2010
    Location
    Chicago
    Posts
    154
    Does anyone know which script it was that fixed this issue in a prior version of TeamSpeak 3? I need to re-run it for an old backup of my database.

    Quote Originally Posted by ANR Daemon View Post
    Let me guess.
    You used MySQL "root" or equivalent user with SUPER privilege to connect to the database?
    Why would that have anything to do with bad encoding of text fields in the database?

  7. #7
    Join Date
    December 2004
    Location
    RF
    Posts
    3,007
    Because a user with SUPER privileges ignores incorrectly set connection charset (and some other minor errors, which for a regular user would cause connection failure).

    Oh, also,
    http://mysqlserverteam.com/sushi-bee...-in-mysql-8-0/
    http://mysqlserverteam.com/new-colla...n-mysql-8-0-0/
    http://mysqlserverteam.com/mysql-8-0...n-the-details/

  8. #8
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,368
    Why are people moving from SQLite to something with generally less performance?

  9. #9
    Join Date
    December 2004
    Location
    RF
    Posts
    3,007
    Out of ignorance, mostly.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: March 14th, 2013, 10:06 AM
  2. Unicode workaround?
    By willy_sunny in forum Client Plugins / Lua Scripts
    Replies: 17
    Last Post: October 14th, 2010, 08:12 AM

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
  •