Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 8 of 8
  1. #1
    Join Date
    August 2007
    Location
    Bangkok Thailand
    Posts
    44

    Channel Description Keeps disappearing frequenly

    I'm running TS3 with mysql. My Database works fine since I'm running it for many purpose. I can notice that only the descriptions stored in UTF-8 disappeared, not all of them, just the most part but English descriptions are still alive.

    I don't think it's MySQL problems since it runs fine for 3 and half years with many (web)applications in UTF-8.

    Any suggestions or helps will be highly appreciated.

  2. #2
    Join Date
    December 2004
    Location
    RF
    Posts
    3,008
    What the client encong set for user you use to connect to database?

  3. #3
    Join Date
    August 2007
    Location
    Bangkok Thailand
    Posts
    44
    Absolutely an UTF-8. If it isn't, I couldn't store japanses or Thai into my channels description for sure.

  4. #4
    Join Date
    June 2002
    Location
    Krün / Germany
    Posts
    1,638
    thats an issue with the sql table structure...

    sqlite does not care if you do varchar(255) or varchar(5)
    mysql does care... since its varchar(255) your descriptiongs get truncated after 255 chars.

    Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions

    so if you got such a newer mysql version, just alter the table and increase it to an varchar(8192) (max size of channel description).

  5. #5
    Join Date
    October 2008
    Location
    Alberta, Canada
    Posts
    166
    Or change it from type varchar(x) to text().

  6. #6
    Join Date
    August 2007
    Location
    Bangkok Thailand
    Posts
    44
    I have 5.1.41. Thank you for an answer. But I wonder which one is channel description table. Is it channel_properties > value?

  7. #7
    Join Date
    June 2002
    Location
    Krün / Germany
    Posts
    1,638
    yes, sorry.

  8. #8
    Join Date
    August 2007
    Location
    Bangkok Thailand
    Posts
    44
    Thank you. I think my server is fine now. I wish TeamSpeak 3 goes full in a very soon!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Resolved] Channel Description
    By Tutas in forum Permission System
    Replies: 2
    Last Post: June 5th, 2013, 04:15 PM
  2. Channels disappearing? Channel limit?
    By xMachoMancha in forum Server Support
    Replies: 3
    Last Post: November 15th, 2012, 02:32 PM
  3. [Resolved] channel description editor change wrong channel
    By Enceladus in forum Bug Reports [EN/DE]
    Replies: 2
    Last Post: June 13th, 2012, 10:14 AM
  4. Channel Admins are unable to change Channel Description
    By sinister_evil in forum Permission System
    Replies: 4
    Last Post: January 17th, 2012, 03:13 PM
  5. channel description with uploaded channel images
    By Fundaris in forum General Questions
    Replies: 1
    Last Post: September 15th, 2010, 04:10 PM

Posting Permissions

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