Forum

Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    December 2009
    Location
    Silicon Valley
    Posts
    10

    255 Character channel descriptions

    So I run my server with mySQL We tend to use really long descriptions in our channel descriptions. With a 255 character limit though descriptions are lost on reboot. Is there any other suggested value types or settings that would b e okay to use in my database structure for channel_properties structure for value it has ts3.channel_properties.value varchar(255)

    Can it be change safely to allow a larger amount of data and still make sure everything works okay?

  2. #2
    Join Date
    May 2010
    Posts
    6,310
    Hello

    You can try to change VARCHAR to TEXT.
    Attention make a backup before all change in your database.

    Information:
    If your description is too long you can write a web link.
    Description is not a litterature text

  3. #3
    Join Date
    December 2009
    Location
    Germany
    Posts
    2,354
    Instead of using TEXT, you can still use VARCHAR, just use a bigger length, maybe 2000 or something like that. Approx 65000 is maximum of VARCHAR with MySQL 5, should be more than enough for all channel descriptions.

  4. #4
    Join Date
    May 2010
    Posts
    6,310
    @Stefan1200

    According to the ANSI SQL VARCHAR field is between 1 and 255. To set more would create bugs.

  5. #5
    Join Date
    December 2009
    Location
    Germany
    Posts
    2,354
    Quote Originally Posted by florian_fr40 View Post
    According to the ANSI SQL VARCHAR field is between 1 and 255. To set more would create bugs.
    We do not use ANSI SQL, we use MySQL. And if you do not believe me, take this :P :
    http://dev.mysql.com/doc/refman/5.1/en/char.html

    Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 65,535.
    So this is not a bug, but a feature .

  6. #6
    Join Date
    May 2010
    Posts
    6,310
    OK

    Try with this, you will see...
    (Make a backup before)

  7. #7
    Join Date
    January 2010
    Location
    Secret Base in Arctic Region
    Posts
    1,671
    We have extended the channel description months ago and it still works...

    @Stefan: ANSI is not a DBMS but an Organisation for Standards, like our DIN.

  8. #8
    Join Date
    December 2009
    Location
    Germany
    Posts
    2,354
    Quote Originally Posted by Alcazar View Post
    @Stefan: ANSI is not a DBMS but an Organisation for Standards, like our DIN.
    I know. There is still nothing wrong with my sentences . MySQL allows more than 255 characters in VARCHAR, it does not matter what the ANSI standard say!

  9. #9
    Join Date
    December 2009
    Location
    Silicon Valley
    Posts
    10
    Thanks everyone for your help I really appreciate the input.

  10. #10
    Join Date
    June 2010
    Location
    DE
    Posts
    19

    Channel Description

    If the intent is that the channel description is limited to 255 characters?
    I use a MySQL database, and there is in the structure to varchar (255). Why is this not Strucktur to text?
    Would be good if that is resolved with the next update, without intervening manual is necessary.

  11. #11
    Join Date
    June 2011
    Posts
    2

    Unhappy 255 Character channel descriptions

    On my TS3 server... 3.0.0-rc1 [Build: 14468] on FreeBSD

    I've noticed that in several channels that have had descriptions that were set longer than 255 characters before I updated from beta30 to the rc1 seem to have be truncated. This has been brought to my attention by several of my users. Everyone is running the RC2 client.

    Did I miss something when I upgraded or is this actually a bug?

  12. #12
    Join Date
    December 2009
    Location
    Germany
    Posts
    2,354
    By default TS3 server beta 30 had a limitation of 255 characters at the channel description (because the MySQL table column was a varchar(255)).

    Just check if your MySQL table column for the channel description is now bigger, if not, change the size to varchar(8000) or something like this.

  13. #13
    Join Date
    June 2011
    Posts
    2
    Ah! Thanks. That explains a few things... I spoke with one of my other admins and they also reminded me that we switched from the sqlite to mysql on top of it all. That fixed it.

  14. #14
    Join Date
    July 2010
    Location
    Madrid
    Posts
    106

    Channel_Properties columm value

    Hi guys , I look at my server log that Channel_Properties columm value is to short varchar(255) .

    Could i set to 4096 maybe without problem?

    I run Server Version: 3.0.0-rc1 [Build: 14468], Windows

    Thanks in advance

  15. #15
    Join Date
    June 2008
    Posts
    17,929
    The answer can be found with and without our search function.

    This is from the changelog of your server
    Code:
    === Server Release 3.0.0-rc1 23 May 2011
    ! mysql users, please alter your table channel_properties and 
      extend the "value varchar(255)" field to varchar(8192)
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Channel descriptions not showing.
    By Webspin in forum Bug Reports [EN/DE]
    Replies: 6
    Last Post: July 21st, 2011, 11:11 AM
  2. Channel Descriptions
    By klutch2013 in forum General Questions
    Replies: 1
    Last Post: July 16th, 2010, 01:14 AM
  3. Channel-descriptions
    By par0noid in forum Bug Reports [EN/DE]
    Replies: 1
    Last Post: April 11th, 2010, 02:14 PM
  4. UTF-8 Character problems on channel displays
    By Dark-Master in forum Windows
    Replies: 2
    Last Post: December 28th, 2009, 06:47 AM
  5. UTF-8 Character problems on channel displays
    By Dark-Master in forum Windows
    Replies: 0
    Last Post: December 23rd, 2009, 10:58 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
  •