oompaloompa
asked on
Microsoft SQL database to MariaDB(MySQL)
Trying to transfer data from Microsoft SQL database (SQL_Latin1_General_CP1_CI _AS) into MariaDB using MySQL workbench but whatever i do i get "incorrect string value for column" errors on columns containing various user entered text with various characters, diacritics etc...
Tried MAriadb (Latin1, Latin2, UTF-8 charset)
Tried MAriadb (Latin1, Latin2, UTF-8 charset)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi oompaloompa,
what's the column type in the MS and in the Maria DB?
Any size limitations that can cause problems?
Can you insert such a text manually (insert or update statement) into the MariaDB?
Can you post such a critical text here?
leflon
what's the column type in the MS and in the Maria DB?
Any size limitations that can cause problems?
Can you insert such a text manually (insert or update statement) into the MariaDB?
Can you post such a critical text here?
leflon
ASKER