Why characterset WE8ISO8859P15 is not working properly as WE8ISO8859P1?
TWe have table (table name - party) columns has
names in the format last_name , first_name.
A stored function is called to translate any French characters in this column to English and populate new column with that info. When this was done in character set WE8ISO8859P1 the results were correct.
But when the character set for server was changed to WE8ISO8859P15 and the same stored function was run data was totally different and not right - at times comma was lost and two names combined, or space was lost.
Could anyone give me any hint on how to fix this or why this is happening?
A stored function is called to translate any French characters in this column to English and populate new column with that info. When this was done in character set WE8ISO8859P1 the results were correct.
But when the character set for server was changed to WE8ISO8859P15 and the same stored function was run data was totally different and not right - at times comma was lost and two names combined, or space was lost.
Could anyone give me any hint on how to fix this or why this is happening?
0