CHARACTER SET (cp1251 OR UTF8)

[enigmas]

Greetings to all.

I from Moscow, and at me have arisen a problem, all time TeamSpeak worked through a file .db, but recently have translated its work through mySQL and here have begun...:-(
In mySQL I see in the necessary coding the name of channels, etc., and here at call and TeamSpeak, all in signs on a question.... As well as what it is possible to make to correct? Whether it is possible to make somehow compulsory changes of heading as in php?

As I have understood this file (mysql_sql/read_channel, sql) is responsible for reading the information on channels from mySQL. But if I in it enter CHARACTER SET cp1251 COLLATE cp1251_general_ci or something about it, it gives out a mistake.

Help to adjust TeamSpeak that it understood the necessary coding.

Excuse for my English :rolleyes:

[Reedy Boy]

Greetings to all.

I from Moscow, and at me have arisen a problem, all time TeamSpeak worked through a file .db, but recently have translated its work through mySQL and here have begun...:-(
In mySQL I see in the necessary coding the name of channels, etc., and here at call and TeamSpeak, all in signs on a question.... As well as what it is possible to make to correct? Whether it is possible to make somehow compulsory changes of heading as in php?

As I have understood this file (mysql_sql/read_channel, sql) is responsible for reading the information on channels from mySQL. But if I in it enter CHARACTER SET cp1251 COLLATE cp1251_general_ci or something about it, it gives out a mistake.

Help to adjust TeamSpeak that it understood the necessary coding.

Excuse for my English :rolleyes:

Try using this program to create a dump straight into MySQL

http://forum.goteamspeak.com/attachment.php?attachmentid=572&d=1109333541


Works fine for me

[Reedy Boy]

Try using this program to create a dump straight into MySQL

http://forum.goteamspeak.com/attachment.php?attachmentid=572&d=1109333541


Works fine for me

And for the MySQL_sql Scripts

Use
http://forum.goteamspeak.com/attachment.php?attachmentid=1050&d=1164623354


As a side point

Where are you setting the character set?

[enigmas]

Thanks, but I just used these programs and files.

Here, look... I shall show all in pictures...

[enigmas]

I had such problem, at creation of the channel, it does not wish to write down it in mySQL.

24-12-06 11:23:39,ALL,Info,server, Server init initialized
24-12-06 11:23:39,ALL,Info,server, Server version: 2.0.20.1 Win32
24-12-06 11:23:40,ALL,Info,server, Starting VirtualServer id:1 with port:8767
24-12-06 11:23:40,ALL,Info,server, Server init finished
24-12-06 11:26:01,ERROR,All,SQL, ExecSQL Error: EDatabaseError.
#23000Duplicate entry '0' for key 1 in query: insert into ts2_channels
(i_channel_server_id,
i_channel_parent_id,
b_channel_flag_moderated,
b_channel_flag_hierarchical,
b_channel_flag_default,
i_channel_codec,
i_channel_order,
i_channel_maxusers,
s_channel_name,
s_channel_topic,
s_channel_description,
s_channel_password,
dt_channel_created)
values
(1,
-1,
0,
0,
0,
0,
3200,
150,
'ûâïöóïöóï',
'',
'',
'',
'24122006112601765');

24-12-06 11:27:06,ALL,Info,server, Server shutdown initialized
24-12-06 11:27:08,ALL,Info,server, Server shutdown finished

[Reedy Boy]

I had such problem, at creation of the channel, it does not wish to write down it in mySQL.

Thanks for the info

I am using the charset of latin1 and collation latin1_swedish_ci

It works fine...

But it looks like you are using russian characters


It would look like that TS doesnt fully support those characters, hence showing them as ?? and such in teh display list, whereas phpmyadmin shows it all fine

[enigmas]

It is necessary to make an opportunity in a file mysql_sql/read_channel,sql, etc., an opportunity to insert CHARACTER SET cp1251 COLLATE cp1251_general_ci or compulsory change of the coding at data reading.

- > select * from ts2_channels where ('i_channel_server_id = :iServerID and i_channel_id = :iChannelID' *CHARACTER SET cp1251 COLLATE cp1251_general_ci) < -

[enigmas]

Help plzz :o

[Reedy Boy]

Help plzz :o

The database looks to be storing it properly

Its just TS not displaying it....


Looking at the screenshot for the channel create, you show us then that the text is showing properly, so that shows TS it properly

So its something with the SQL queries it would seem

It could be the storing rather than the reading

[enigmas]

When I create the channel from a chat, it stores data in baseTS at itself(himself). And here TS reading mySQL occurs, likely, in latin to the coding, that is why and cp1251 it cannot read through in the obvious image. It is necessary to correct it in the new version or to make possible to change the coding of reading TS to mySQL.

By the way when there is a new version?)

[Reedy Boy]

When I create the channel from a chat, it stores data in baseTS at itself(himself). And here TS reading mySQL occurs, likely, in latin to the coding, that is why and cp1251 it cannot read through in the obvious image. It is necessary to correct it in the new version or to make possible to change the coding of reading TS to mySQL.

By the way when there is a new version?)

There is a TS2 Client beta
http://www.goteamspeak.com/index.php?page=downloads&id=9a



TS3 is due next year

[ANR Daemon]

Grrrrrrrrrrrrr
http://forum.goteamspeak.com/showthread.php?p=147009#post147009
Look here for methods if connection TS & MySQL together and to setting them up properly...

И для кого я всё это писал, спрашивается? Для себя что ли? Можно немного уважения к чужой работе проявить и по крайней мере прочитать написанное?
Или хотя бы сказать "да, я всё сделал вот так, и ниххх не работает, где засада?".
В твоем посте не видно, как ты подключал TS к MySQL.