CI Session problem

[eluser]Akinzekeel[/eluser]
OK I see where this is going and I also realize that I caused the problem myself (D'oh!).

For performance reasons I usually change the userdata field from TEXT to VARCHAR because then the table engine can be set to MEMORY instead of MyISAM (MEMORY does not allow TEXT). According to the profiler, the session query is about 3 times as fast with a MEMORY table (may be marginal anyway, but hey, I take what I can get ^^).

What I, however, misunderstood, is that TEXT is in fact 65535 characters in length and not 255 (that would be SMALLTEXT). So I was always worried to save a lot of things in userdata() because 255 characters really isn't a lot to hold cart data, especially when serialize() and UTF-8 are used...

I think I somehow mixed up MySQL with MS Access data types, because in MS Access TEXT is (up to) 255 characters