Overview: In Informix is it possible to enforce
ASCII for a database or instance.
Details: I am trying to enforce
ASCII in an instance of informix for a while. This is to help have a smooth transition between char sets:
ISO Latin-1 (819) and
UTF8. I would like this to be done by cleansing my current data of non
ASCII characters and then exporting the data from the databases. These steps have already been done.
Then setting the character set to enforce
ASCII. However I cannot find a character set that I can use that my instance allows me to change the db_locale too. My current db_locale is default aka
ISO Latin 1 or
819. After I figure out the character set. I believe that I can figure out the rest. It should be just importing the data to a new database with the db_locale set to an
ASCII char set.
Is this possible? I am also open to other ways of setting or enforcing
ASCII at the database level.