I'm communicating with a MS SQL 2005 Server via Flex 2.01. my original query:
SELECT code, code_description, sub_category FROM flexing_price_list WHERE (code LIKE 'al%') UNION ALL SELECT code, code_description, NULL FROM flexing_products WHERE (code LIKE 'al%') gave me the error: "Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict" So I checked out my database, via MS Server Management Studio Express, and saw that the collation type for my database was set to SQL_Latin1_General_CP1_CI_AS. I guess this is the default setup as I have not changed this myself. Anyway, to get around this I modified my query to SELECT code COLLATE SQL_Latin1_General_CP1_CI_AS, code_description COLLATE SQL_Latin1_General_CP1_CI_AS, sub_category COLLATE SQL_Latin1_General_CP1_CI_AS FROM flexing_price_list WHERE (code LIKE 'al%') UNION ALL SELECT code COLLATE SQL_Latin1_General_CP1_CI_AS, code_description COLLATE SQL_Latin1_General_CP1_CI_AS, NULL FROM flexing_products WHERE (code LIKE 'al%') which returns the required data in MS Server Management Studio Express. However, this data when brought into Flex as an arrayCollection does not show up in the dataGrid which is bound to the arrayCollection. The correct number of record (blank) lines are present, but no readable data. How can I correct this please?