Unanswered: (codepage-) problem with comment character
we encounter a problen while we try to execute a SQL statement from an AIX (codepage ISO 8859-1 Western European) to a target database on an other machine. The target database is running wiht the codepage DB2 IBM EBCDIC German ID220.
We need to send the comment character after the statement (because the tool we use generates additional code after our statement) to ensure the proper execution. After receiving an syntax error while we use the standard comment character '--', we assume that the different codepages lead to an conversion error between the two machines. If this assumption is correct we need to know which source codepage character will be converted to the comment character in the target codepage. Can anybody help ? Thanks.