Dear friends,
I'm trying to make an update to a table in SQL Server 2008 R2, but the field writes only 8000 characters.
The column is set to 'text', but I already tried to change it to 'varchar (max)' without success.
I've also used 'cast' ('variable' as text) 'and' cast ('variable' as varchar (max)) '
When you do the same update by the SQL console or enter more than 8000 characters manually, it works (through Microsoft Visual Studio).
sql_Up = "UPDATE ABVC_Eventos SET titulo_eve = '" & Strip(Evento) & "', cod_sup_eve = '" & Strip(cod_sup_eve) & "', cod_sup2_eve = '" & Strip(cod_sup2_eve) & "', texto_eve = CAST('" & Strip(texto_eve) & "' AS TEXT), WHERE id_eve = '" & Strip(Cod_Evento) & "'"
set Rs_sqlUp = bco.Execute(sql_Up)
The 'Strip' function is for sanitization.