Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi Christian:
>I use MEDIUMTEXT for memo fields.
>Also, in the mysql.ini file you have to add those lines (restart the service after modifying the file):
># Large log files because we use a lot of large fields.
>innodb_log_file_size=128M
>innodb_log_buffer_size = 8M
>innodb_autoextend_increment = 8M
>innodb_flush_log_at_trx_commit = 1
>After you changed this, you need to stop the mysql service, then delete the log files (ib_logfile0 and ib_logfile1), and then start the mysql service. >This will rebuild the logfiles so the startup will take a few seconds longer.
>Also, add this line so you can have sufficient connections:
>max_connections = 200
>And, last but not least, add this line:
># To avoid slow connection because of a reverse DNS lookup:
>skip-name-resolve
All that??
Well. The problem is not the field type of database when the cursor transform them as memo fields. The problem is still there. Apparently you can't help converting text fields in database table as text fields in local cursor or table.
First I installed the driver as you told me. Then I configured it. Then when I saw the data in the SQLSTRINGCO... instruction is the same of OBDC driver I deleted the "mysql" item and the connection worked well. You perhaps mean if I restart the machine SQLSTRING... doesn't work anymore?
Thank you. I'll go on testing.
Héctor
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement