Cache Destination & Characters Problems

[Niinetan]

Cache operate such as "cache_get_row" does't support multy-dimensional arrays...
E.X:
enum info { name[50],}
new pinfo[x][name],
cache_get_row(x, x, pinfo[x][name]);
printf("%s", pinfo[x][name]);
//nothing is printed...

Whatever charset is, it doesn't supprot Chinese. Every Chinese word queried from database is "?".
But R7 works well.Neither of them happened.

[maddinat0r]

You have to set the size in the native manually. Take a look at the wiki for more information.

Regarding the charset issue, can you try R34 and see if it works?

[Niinetan]

I know...x just stand for an int...
Oops...new pinfo[x][name] -> new pinfo[x][info]
Well,I said that these codes work well at R7,therefore,it's not the problem of variable declaration...
You can try to compile these codes.Then run the GM u'll find out what happens.

As for charset issue...R34 still does not work.

[carmoIn]

you need to do this, since this is a compiler bug.

enum info { name[50],}
new pinfo[x][name],
cache_get_row(x, x, pinfo[x][name], .max_len =50);
printf("%s", pinfo[x][name]);

[Niinetan]

CarmoIn...Well, it seems that i have to attach some images...

[Niinetan]

What I expected is "中文测试"(means chinese characters test), but query result is "????". Charset is correct.
As what I mentioned above, same codes work fine at R7.

[Niinetan]

Find out the reason of issue-multy-dimensional arrays...
native cache_get_row(row, field_idx, destination[], connectionHandle = 1, max_len = sizeof(destination));
cache_get_row etc. use sizeof to get the max_len of the string, but 'sizeof' doen't support multy-dimensional arrays.

[maddinat0r]

That's why I said you have to manually set the size. Try your code with R8 (and without setting the size) and voila, it won't work again (because of the security improvements in R8). The reason your code works with R7 is because R7 has security flaws (and thus your code, that's why you have to change it if you want to use R8+ correctly (by manually setting the size in the native)).
Also technically the sizeof operator supports multi-dimensional arrays, it just doesn't return the correct size if it's used with an enum array.

I'll try to reproduce the issue with the charset, I'll write here when there's some progress.

[Niinetan]

Got it, thx.

[maddinat0r]

There was indeed a bug regarding the charset function in the plugin, mysql_set_charset wasn't always correctly executed (only for the internal unthreaded connection).
Here is the version which includes that fix. Can you try to reproduce that bug and tell if it's working or not?

[Niinetan]

It works! :)

[maddinat0r]

Okay, great, thanks for testing.