Has anyone tangled with Sybase text (and/or image) datatypes and the writetext/readtext commands from PHP?
I have the CT library linked in, but because Sybase does not support these datatypes as either parameters to stored procedures (or as @variables within stored procs either) I was wondering what the best practice would be to manipulate (retrieve and store) blobs like these especially if minimal logging was mandated. The SQL Advantage statements required are like ... declare @vb16 varbinary(16) select @vb16 = textptr(col) from tbl where key = "therowkey" writetext tbl.col @vb16 "Very large text string!" Has anyone found a way to do this from PHP or do I have to sanction direct access to the table for insert and update commands like ... sybase_query('insert tbl (key, col) values ("therowkey", "hello world")') and sybase_query('update tbl set col = "hello world" where key = "therowkey"') Cheers, Frank. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php