Xwolf

OK I will do that what you say. Thank you very much.

@TheDcoder In fact, I can modify the set from remote MySQLServer throught browser. And i checked the set of server side, the value is 1073741824. Now i want to modify the value of the client side.

Hello everyone. I have a problem with "Error: 2006 MySQL server has gone away". Because i want to send a binary data of a big picture to the MYSQL server. I have read the documentation of mysql "https://dev.mysql.com/doc/refman/8.0/en/gone-away.html". Maybe I think the issue is that the max_allowed_packet is too small. I didn't know how to set the value of max_allowed_packet on the client side. Please help me thx.

Good jobs. Thanks.

I was known how to transport a txt file.But when i was attemp to transport a exe file there was some problems. What i received can not run correctly. For example,i was receive the abc.exe file.When i run it that it was encounter a fails.

I had searched a lot of topics for this that how to transport jpg,rar or exe files. But I can not find anythings. Please help me.Thanks a lot. I was known how to use TCP for transporting a txt file. But when i was attemp to transport a exe file there was some problems. What i received can not run correctly. For example,i was receive the abc.exe file.When i run it that it was encounter a fails.

cool,good job...

Gob jobS. Thanks. But i encounter some problems. Success when i used it to transfer .txt files. Fail when i used it to transfer .rar or .exe files.

Nice code. 3Q...

Nice job. Appreciate!

Nice code

$string = "abc好abc" $z1 = StringToBinary($string,4) ConsoleWrite($z1 & @CRLF) $z2 = BinaryLen($z1) ConsoleWrite($z2 & @CRLF) ;Result1 ;0x616263E5A5BD616263 ;9oÝ÷ Ù«­¢+ØÀÌØíé}¥±ô¥±=Á¸ ÅÕ½ÐìĹÑáÐÅÕ½Ðì°Äؤ((ÀÌØíèÄô¥±I ÀÌØíé}¥±¤) ½¹Í½±]É¥Ñ ÀÌØíèĵÀì I1¤(ÀÌØíèÈô ¥¹Éå1¸ ÀÌØíèĤ) ½¹Í½±]É¥Ñ ÀÌØíèȵÀì I1¤()¥± ±½Í ÀÌØíé}¥±¤(((íIÍÕ±ÐÈ(íÈÈäÀäí Note: The result2 was something strange. Looking the result2 "abc好abc8" The word "8" was behind the word "c". In my opinion ,when i use code "ConsoleWrite($z1 & @CRLF)". It should in this way abc好abc 9 Help,help ...

ASCII or UFT8 ...? In fact,i didn't know what i had used. I just put "abc好abc" into the file test.txt . And i found that the size of file was 8 bytes (without @CRLF). IF i put the "enter"(with @CRLF) ,then the size of file is 10 bytes.

Great! A new way to deal with this problem. Cheer! Peter

a b c 好 a b c @CR @LF 1 1 1 2 1 1 1 1 1 1+1+1+2+1+1+1+1+1=10 Total is 10. Am i right?

3Q Thanks for everyone above.

Sorry,but in fact the string "好" is a word which have 2 bytes.

Question:How do i know the bytes of a string? For example: $str = "abc好abc"NOTE: "好" is a chinese word which have 2 bytes. how can i get the bytes of variable $str Thanks for everyone.

Thanks so much !!! Ho my god. I have read the helpfile everyday, but didn't find this function. I'm very sorry to ask so stupid question.

Question:How to get the number of lines in a file? For example, there is the file "test.txt",which have 3 lines. So,how can i get the "3"? 3Q for everyone

Yes KaFu I am also confusing about "atomic commit".

Thank you very much! KaFu This is my result when using your code. +>21:21:10 AutoIT3.exe ended.rc:0 +>21:21:11 AutoIt3Wrapper Finished >Exit code: 0 Time: 2.174 I will think about your code. Thanks again for your help.

It was too slow to insert data. Can somebody help me speed it up. Thanks in advance for any help. Code #include <sqlite.au3> #include <sqlite.dll.au3> _SQLite_Startup() _SQLite_Open("abc.db3") _SQLite_Exec(-1,"Create table abc(id)") For $i=1 To 100 Step 1 _SQLite_Exec(-1,"Insert into abc values ('1')") ConsoleWrite($i & @CRLF) Next _SQLite_Close ("abc.db3") _SQLite_Shutdown ()

I agree with that

Sorry , for my poor English. lol I think the problem was that keyword "INSERT". You can test the following code. #include <sqlite.au3> #include <sqlite.dll.au3> _SQLite_Startup() _SQLite_Open("abc.db3") _SQLite_Exec(-1,"Create table abc(id)") For $i=1 To 100 Step 1 _SQLite_Exec(-1,"Insert into abc values ('1')") ConsoleWrite($i & @CRLF) Next _SQLite_Close ("abc.db3") _SQLite_Shutdown ()oÝ÷ Ù8^­ë.ÛºÚ"µÍÉÝÌMNL ]]ÒUË^H[YÎÉÝÌMNL H]]Ò]ÕÜ[ÚYÝÑ^]ÛÙNU[YNM N It spended 14 seconds to insert only 100 data.