This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

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?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.