Channel Description Keeps disappearing frequenly

[Dark-Master]

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.

[ANR Daemon]

What the client encong set for user you use to connect to database?

[Dark-Master]

Absolutely an UTF-8. If it isn't, I couldn't store japanses or Thai into my channels description for sure.

[R. Ludwig]

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).

[UF|Renegade|LTG]

Or change it from type varchar(x) to text().

[Dark-Master]

I have 5.1.41. Thank you for an answer. But I wonder which one is channel description table. Is it channel_properties > value?

[R. Ludwig]

yes, sorry.

[Dark-Master]

Thank you. I think my server is fine now. I wish TeamSpeak 3 goes full in a very soon!