>>Hi everybody,
>>
>>We are using DSN to connect to SQL Server and sql pass through. In my quick tests few months ago I was having troubles with varchar(max) fields.
>>
>>So, I have several questions.
>>
>>1. Can we use nvarchar(max) and VFP with ODBC connection or better to use nvarchar(4000) to be safe?
>>
>You can do a CAST(varcharmax_field AS TEXT) with ODBC SQL 2005/8 driver
>or uses old ODBC SQL 2000 that does an implicit CAST( AS TEXT), but with this you lose other SQL 2008 behaviours.
>
>>2. For editing nvarchar fields (to support other languages) which controls should I use on my forms? Also, assuming we may want to use right to left languages, what additional considerations should be? The languages to support are defined by the user.
>>
>>Thanks a lot in advance.

Actually, seems like I don't have any problems with varchar(max). My latest tests today retrieved this field just fine.