>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.