Hi,
I have a column in a table declared as a T_description (500) which is a varchar (500). In the application I save my record which updates the column with 350 chars (for e.g.) the update works and when select the column in query analyser the column has been updated. In the app only 256 chars are showing in the field. This is PB 9, SQL server 2000 using ODBC to connect to db. It is not the dw limit of field as this is 500. Is it something to do with the data types in odbc? Do ODBC varchar columns have a limit of 256 characters. Can I change the mapping (i.e. map SQL Server VARCHAR to ODBC Text, instead of SQL Server VARCHAR to ODBC VARCHAR)? Or is this not the problem? Thanks, Donna
I have a column in a table declared as a T_description (500) which is a varchar (500). In the application I save my record which updates the column with 350 chars (for e.g.) the update works and when select the column in query analyser the column has been updated. In the app only 256 chars are showing in the field. This is PB 9, SQL server 2000 using ODBC to connect to db. It is not the dw limit of field as this is 500. Is it something to do with the data types in odbc? Do ODBC varchar columns have a limit of 256 characters. Can I change the mapping (i.e. map SQL Server VARCHAR to ODBC Text, instead of SQL Server VARCHAR to ODBC VARCHAR)? Or is this not the problem? Thanks, Donna