Comparison of data - Help

[naveentp]

Hi,
I have data retrieved from two databases [SQL Server and Oracle] with different charactersets. I need to compare the data for equality.
The issue is for extended ascii characters in the data - the simple string.compare() comparison fails, so how can I compare them.? Please help
Thanks in advance,
With Regards,
Naveen

 

[cjard]

Sorry i cant help directly with this, but I seem to recall seeing somewhere a way to convert extended ascii to plain.. Only thing is i forget how..

You can do the conversion yourself with something like ORacle TRANSLATE:

SELECT Translate(someColumn, "àáâãäåæçèéêë", "aaaaaaaceeee") FROM table

every occurence of a character from the first string, is replaced with the corresponding character in the second