Re: [PHP-DB] Postgres and gzcompress

2006-09-07 Thread John DeSoi
If your goal was to compress the data, this seems counterproductive since base64 will inflate it by 33% or more. I would recommend using a bytea column and a prepared statement to insert or update. This will be faster and you won't have to worry about escaping. On Sep 6, 2006, at 11:18 P

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Mitch Miller
Yeah ... it ain't purdy, and it sure doesn't scale so you have to be careful where you use it. This is usually more of a presentation issue that I'd suggest be left up to the application doing the display of the data. As an example, I believe Microsoft Excel has a crosstab function that can

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Chris
Mitch Miller wrote: K.A.Bouton wrote: > I need the output of my sql to be a multidimensional array as follows. then Chris wrote: > You won't be able to get an sql query to return in that format (I know > what you're trying to do, I've used the same chart software). This is my MSSQL Server s

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Mitch Miller
K.A.Bouton wrote: > I need the output of my sql to be a multidimensional array as follows. then Chris wrote: > You won't be able to get an sql query to return in that format (I know > what you're trying to do, I've used the same chart software). This is my MSSQL Server solution, and yep, it out

Re: [PHP-DB] tsearch2, PHP5 with Bidi + US-ASCII

2006-09-07 Thread Chris
Michelle Konzack wrote: Hello Nerds, Geeks and Gurus, I have a multilingual Database of arround 380 to 390 GByte with data in environement 60 languages. the entired Database is INICODE. Since version 5, PHP is supporting UNICODE very nice, but whenever I want to search a bidi-string (farsi, ara

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Chris
K.A.Bouton wrote: I need the output of my sql to be a multidimensional array as follows. chart [ 'chart_data' ] =3D array ( array ( "", "2001", "2002", "2003", "2004" ), array ( "AAA", 0, 10, 30, 63 ), array ( "BBB

[PHP-DB] tsearch2, PHP5 with Bidi + US-ASCII

2006-09-07 Thread Michelle Konzack
Hello Nerds, Geeks and Gurus, I have a multilingual Database of arround 380 to 390 GByte with data in environement 60 languages. the entired Database is INICODE. Since version 5, PHP is supporting UNICODE very nice, but whenever I want to search a bidi-string (farsi, arabic or hebrew) it returns

[PHP-DB] sql output to a multidimensional array

2006-09-07 Thread K.A.Bouton
I need the output of my sql to be a multidimensional array as follows. chart [ 'chart_data' ] =3D array ( array ( "", "2001", "2002", "2003", "2004" ), array ( "AAA", 0, 10, 30, 63 ), array ( "BBB", 100, 20,