Hi,
Does anybody know if it is possibile to change the codepage of the database e.g. from ibm850 to 1252 without dump & load the database?
Thanks in advance for the answers!
yes, providing you use the correct -cpstream/cpinternal values during the D&L, but you can also achieve the same thing with "proutil db -C convchar convert 1252" and idxbuild
yes, providing you use the correct -cpstream/cpinternal values during the D&L, but you can also achieve the same thing with "proutil db -C convchar convert 1252" and idxbuild
Remember to load any word break tables and collation table .df files after conversion. Both 1252 and ibm850 have 'basic' collations, but they are not the same, and you can't see this by looking at the Data Dictionary or Data Administration tools.
Regards,
Paul.