convert DB from MSSQL to MYSQL

[waikiki83]

hello guys need your help once again...
we are trying to migrate our db from MSSQL to MYSQL
we bought a tool for migration and the migration went smoothly
however, when the details of the tickets are shown in OTRS it is garbage.
all other data have no problem subject of emails, sender, etc...

and when i use the mysql workbench to view the article details or body i could see the body of the email just fine.

on the mssql database we are using iso-8859-1 as default charset.

any clue or idea on whats going on?

[Wolfgangf]

have you tried the tools from mysql for converting?

[mulder33]

have you tried the tools from mysql for converting?

I would try this as well...

[lacompostela]

i have the same problem. anyone?

[jojo]

this typically would require some development...

[ferrosti]

mssql database we are using iso-8859-1 as default charset

Do you have mySQL configured to use the same codepage as default, as well as your tables codepage?
Submit a

Code: Select all

SHOW CREATE TABLE article_plain;

and see the last line.

BTW: OTRS starting at 3.0 should per default use UTF-8!

[waikiki83]

Do you have mySQL configured to use the same codepage as default, as well as your tables codepage?
Submit a

Code: Select all

SHOW CREATE TABLE article_plain;

and see the last line.

BTW: OTRS starting at 3.0 should per default use UTF-8![/quote]

Thanks for the command and i found out that it is using UTF-8.
Do you have any idea on how i can convert this to ISO-8589-1.
Apparently, the default coding in MSSQL is ISO.

Thanks in advance....

[ferrosti]

There were enough hints by others in this thread! Go for the mySQL tools.