Hello,
I had some problems with a code in SELECT ...
example:
SELECT dados FROM banco WHERE CPF='$CPF' // com o código assim estava dando alguns erros pois o bd era em SQL e o Servidor windows.
The solution was:
SELECT CAST(CAST([dados] AS VARCHAR(8000)) AS TEXT) AS dados FROM dbo.banco WHERE CPF='$CPF;
I wanted to know if you have a simpler solution that does not need such extensive code ...
Type, if I want to drill down the fields of the table and use 4 fields, it only works if I put the CAST where it is nVARCHAR .
Note: I can not change in the nVARCHAR bank to only VARCHAR .
Thank you in advance!