Answer the question
In order to leave comments, you need to log in
How to insert records from sql server into mysql?
Greetings.
I cannot understand in what a problem...
I Do insert into mysql table from select sql server table.
When inserting fields in varchar format without longtext, everything is inserted normally. When inserting varchar + longtext , the varchar is filled with null s. That is, I take from mssql nvarchar 255+ nvarchar max is inserted into varchar + longtext on the mysql side via an odbc link. And so values of fields varchar, mysticism are lost.... Help!
In general, the link behaves strangely, when adding a field with varchar max to longtext, it fails with a fatal error.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question