Forums / Setting Up Categories, Products, Attributes / problem with products_options_values as a BLOB

problem with products_options_values as a BLOB

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

8 Oct 2007, 9:21 PM

audleman

New Zenner

Join Date:: Jul 2007
Posts:: 69
Plugin Contributions:: 0

problem with products_options_values as a BLOB

I am writing a tool to download orders and process them. I am trying to use ODBC to download the zen_orders_products_attributes table. The field products_options_values, which contains the text of attributes, is of type BLOB. When I try to get the values from my ODBC connection, nothing comes out. I'm wondering if it's possible to get data from variables of type BLOB from ODBC?

Alternately, Can I change the type of products_options_values to VarChar? I'm not using attributes for anything that needs a size that blob allows, I just wonder if I will screw something else up if I make the change.

Thanks,
Kevin

8 Oct 2007, 9:50 PM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: problem with products_options_values as a BLOB

You can change the field to TEXT instead of BLOB if you haven't modified the code to store binary data for some reason (which is highly unlikely).

8 Oct 2007, 9:55 PM

audleman

New Zenner

Join Date:: Jul 2007
Posts:: 69
Plugin Contributions:: 0

Re: problem with products_options_values as a BLOB

Thanks Dr Byte! That solved my problem.

Kevin