Question Max Mem for Sting table

[CDWriter]

is there a Max mem our size for t_String table in sql ?

if so where is it in source ?

[Tarissuis]

Kinda weird question:

Soo, according to mysql 5.0.3 and up can store 65,535 characters in a varchar type (which is the type set for the t_string table). Substract 2 bytes for the length of the string, so 65,533 characters is the maximum you can have in your database.

 Spoiler

255 if you're using an older version, which you shouldn't. Also note that by default, 255 is set as the maximum length, at least in my table. You should be able to set that value up to 65k though.

The .lod file can contain anything (as long as your exporter exports everything), however the client only provides a 8192 byte-sized char array, which results in 8192 being the maximum number of characters a single string can hold by default.

 Spoiler

See Engine/Help/Loader/Loader.cpp -> bool TableLoader::load_file( const char* str_path, int strCnt ) for details.

[Wizatek]

Thanks for that information, i didn't know that the max length of a varchar is no longer 255

[LikeToMove]

Originally Posted by wizatek

Thanks for that information, i didn't know that the max length of a varchar is no longer 255

Are you kidding us?

[Wizatek]

No i am dead serious, i guess i should take more time reading changelogs

[CDWriter]

thanks Tarissuis

close topic

[Yannikin]

#closed as requested