Re: locale problem

Fernando, Thank you much! Yes, Guy's blog looks related to the 819 versus1252 problem rather than our specific situation. our scenario would be trying to create a new db (that could contain chinese) on a pre-existing instance that is configured for just english (819). (we are on v10.FC9) A web application would have to hit both db's in order to display the chinese character and the english text together. If I am reading your post correctly, ("Currently you can't make a distributed query on databases with different locales.") , then I don't think this approach is going to work. I don't think I can just switch the whole instance and all of its databases to be UTF8 so that means the only choice left is to export and import every db on the instance and have the locale be utf8. as far as a next release, this was sent in an email from ibm support but no more details regarding it: "The next release of IDS, 11.50.xC6 has features that are meant to help with this translation phase."