Content from TEXT fields not displaying - Classic ASP on Windows Server 2012 machine
Recently I migrated from MSAccess to MariaDB feeding an old Classic ASP Website on a Windows 2012 machine. Everything went smoothly except...
those fields that were a DATA FIELD "Memo" in MSAccess were converted in a TEXT DataType utf8mb4_general_ci If I use Heidi and connect to the database, I can see the content of those fields. They are paragraphs and see the bullet characters the break lines... all is there correctly.
However... when I connect from a webpage (classic ASP) and I call anyone of those TEXT fields, it simply does not display the TEXT field content.
My connection works for everything, I am just adding it as a reference:
<% Dim MM_Connection_STRING MM_Connection_STRING = "DRIVER={MariaDB ODBC 3.1 Driver};TCPIP=1;SERVER=localhost;UID=USERID;PWD=PASSWORD;DATABASE=DATABASE;PORT=3306" %>
<% Dim RECORDSETNAME Dim RECORDSETNAME_cmd Dim RECORDSETNAME_numRows
Set RECORDSETNAME_cmd = Server.CreateObject ("ADODB.Command") RECORDSETNAME_cmd.ActiveConnection = MM_Connection_STRING RECORDSETNAME_cmd.CommandText = "SELECT TEXTField FROM MyTable” RECORDSETNAME_cmd.Prepared = true
Set RECORDSETNAME = RECORDSETNAME_cmd.Execute RECORDSETNAME_numRows = 0 %>
When I go to print the content that is TEXT out on my ASP web page:
<%=(RECORDSETNAME.Fields.Item("TEXTField").Value)%>
the server is simply NOT DISPLAYING the TEXT field content. All other fields that are VARCHAR are displayed without a glitch on the page, from the same table and same database
I am sure I am doing something wrong. Anybody had a similar experience? any suggestion?