User Profile

SelvamaniTaurus · May 28 '19, 01:32 PM

I'm stuck with it still. Thanks for asking.

SelvamaniTaurus · May 27 '19, 11:52 PM

Thank for getting back, NeoPa.

You are correct, even I came across this statement online somewhere. Now my problem is to cheat the SQL compiler with the same string with single quotes in it, when it comes thru the Tool I'm using.

SelvamaniTaurus · May 27 '19, 11:49 PM

You are right! That is why I use the below insert query from the Oracle EDQP Tool, where you could see the N'$?' for SZDSC column which takes the Unicode string to the target field.

insert into Selva_temp_nvar char_05_23_2019
(SZEDLN, SZDSC)
values
(?,N'$?');

Now, my problem is I wanted to convert those single quotes to two single quotes before it hits SQL compiler from the EDQP Tool.

SelvamaniTaurus · May 24 '19, 02:53 AM

If I load with just (?,?) it loads everything but the foreign characters are replaced with ? in the target table.

SelvamaniTaurus · May 23 '19, 08:40 PM

Thank you, Rabbit.

I'm reading the values from an Excel sheet as my source of input and I have some foreign language characters in the strings and in my task I will be using Oracle EDQP as an Interface tool to load them in the Target(SQL Server 2012).

I don't want to do it manually, I wanted to figure out a way to replace them in the SQL query. When I have used a regex option inside the tool(Oracle EDQP)1 to replace...

SelvamaniTaurus · May 23 '19, 06:55 PM

Hello Rabbit,

Thank you for getting back,

select replace(N'РВАТ' ЕЛЬ РЫЧА'ЖКОВЫ Й У'РРВ-101.6', Char(39), Char(34)) Foreign_Chars;

select replace(N'РВАТ' ЕЛЬ РЫЧА'ЖКОВЫ Й У'РРВ-101.6','''', '''') Foreign_Chars;

The above are two queries, I tried.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Replace Single Quote to Double quotes in a String