Character Sets
Posted in 1998
Dear All,
I have a problem:
We have an insert statement that includes the character hex A9. The
statement works on NCR running 7.14, but on HP running 7.23 we get an
-202 error. The column to contain the value is type varcher(255).
The insert statement is executed from a powerbuilder application using
the i-net client. The program builds the string and executes it using
EXECUTE IMMEDIATE. It is not prepared and executed using host
variables and place holders.
We can insert this value into the table using the dbaccess load
command on HP 7.23.
The problem is that the code is deployed on approx 1500 workstations
in branches around Australia. This will be a major show stopper with
our upgrade as once we change to HP all branches will cease to work.
Changing the code at the branches is not an option.
What we need is a solution that can be implemented on the server side,
such as enabling a character set that includes this character but does
not disable the current en_us character set we are using. Or any other
solution that we can implement without changing the code.
As part of the migration we will be copying all data from NCR to HP.
So if a character set exists then this may be an option.
Regards,
Jason