tsql - varchar(max) equivilent in MySQL for T-SQL varchar(max) comparison -


i have following clause

where (     target.sender_name <> source.sender_name ) 

target aliases table in microsoft sql server while source aliases identical table on mysql server linked via linked server

originally had sender_name in both tables text field, trying keep 2 tables incidental, query above clause when, when tried run spat out

the data types text , text incompatible in not equal operator. 

doing bit of looking around learned text in tsql depreciated , should using varchar(max), doing outputted error

the data types varchar(max) , text incompatible in not equal operator. 

looking around seems equivalent varchar(65535) using cause problems in table has 4 text fields , error i'm getting believe same other 3 fields have in same clause

so wondering if there equivalent varchar(max) in mysql can use in clause varchar(max) field in tsql

note: query clause in runs in tsql, it's table on linked server mysql

edit: clause goes update query, checks every field , updates record in of data different, it's ever used sync 2 tables can localize work on servers rather using linked server stuff inner joins


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -