General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only