Re: Problem with columns of type Text and Drupal/Prado/PHP5

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

> It appears that in the Prado viewstate are some characters (binary??) 
> that offend the pgsql TEXT column and write errors occur whereby not all 
> the text is written to the session table, resulting in instability. 
> There is a point in the text stream where some binary data probably 
> causes an EOF or something?

Are you sure it isn't data that is UNICODE? I find it odd that they 
would be storing actual binary strings as session data (but who knows).


> Since mysql TEXT columns are really just BLOBS, and they work fine with 
> the viewstate data, is there a way to just change the column type from 
> TEXT to something akin to a BLOB column in pgsql so that I can use pgsql 
> instead of mysql?

There is, several different things LO and Bytea.


Sincerely,

Joshua D. Drake




--

   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
   Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/