[Army]

Hello, i have MySQL query, but i need to use more than 2048 characters, is it possible, how?

[Borg]

Try to use global variable with this size

[newbienoob]

Can I see the query?

[Army]

Quote:

Originally Posted by Borg Try to use global variable with this size

I think it does not help me.

Quote:

Originally Posted by newbienoob Can I see the query?

It's normal update query, there is no way to make it shorter. It have about 100 variables and all variables needs values. If you have solution, please tell.

[Isolated]

Use strcat.
https://sampwiki.blast.hk/wiki/Strcat

I'll show you query of mine if needed, just PM me.

[Borg]

Try to use 2 queries instead of 1

[Emmet_]

Yes, it's possible. Pawn can create any string size, as long as the computer the script is being compiled on has enough memory to process those cells (remember, 2048 cells is 8192 bytes, around 8 kb).

Start by adding 128 to the string size each time until your queries are perfectly in size and execute correctly.

[Vince]

Quote:

Originally Posted by Army no way to make it shorter. It have about 100 variables

A single table should not contain more than about two dozen fields. Put player information in a separate table, character information in a separate table, weapons in a separate table, vehicles in a separate table, etc.