dbimport & utf8

[t***@gmail.com]

hi all,

We are importing databases and running tests to have them converted into a utf8 environment (version 11.7.FC6 on AIX 6.1 with Primary and Secondary HADR) .
Only one db imports without errors, the rest repeatedly come up with this error message :

202 - An illegal character has been found in the statement.

it seems very time consuming to try and find all those special characters (running into symbols for degrees, various hidden characters, etc) , clean them up and then hope the import works.

Have others found a clean way to get imports like this to succeed?

Thanks,
Tom

[Art Kagel]

Do you have CLIENT_LOCALE and SERVER_LOCALE set correctly?

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by t***@gmail.com
hi all,
We are importing databases and running tests to have them converted into a
utf8 environment (version 11.7.FC6 on AIX 6.1 with Primary and Secondary
HADR) .
202 - An illegal character has been found in the statement.
it seems very time consuming to try and find all those special characters
(running into symbols for degrees, various hidden characters, etc) , clean
them up and then hope the import works.
Have others found a clean way to get imports like this to succeed?
Thanks,
Tom
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

[t***@gmail.com]

doh!
turns out the db_locale was not being set for the others that had issues ....

thanks much