Replace is not working for weird character
I use UPDATE a SET GR_P = REPLACE(GR_P,'','') FROM mytable a to replace things.
But replace function is not working for below charter:
In Query analyzer it works but when I used SSIS Execute SQL task or OLEDB Source then it is giving me error:
No Connection manager is specified.
sql-server oracle replace plsql edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
add a comment |
I use UPDATE a SET GR_P = REPLACE(GR_P,'','') FROM mytable a to replace things.
But replace function is not working for below charter:
In Query analyzer it works but when I used SSIS Execute SQL task or OLEDB Source then it is giving me error:
No Connection manager is specified.
sql-server oracle replace plsql edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
What programming language is this?
– Raymond Chen
Nov 13 '18 at 2:05
not sure. This string character from RTF file.
– Vivan_J
Nov 13 '18 at 15:18
But what programming language is it? Is this MySQL?
– Raymond Chen
Nov 14 '18 at 0:30
PL/SQL. We are using sql server 2014.
– Vivan_J
Nov 14 '18 at 16:47
PL/SQLis Oracle.SQL Serveris Microsoft. If you're using the procedural extension of SQL Server, that'st-sql.
– Allan
Nov 14 '18 at 21:50
add a comment |
I use UPDATE a SET GR_P = REPLACE(GR_P,'','') FROM mytable a to replace things.
But replace function is not working for below charter:
In Query analyzer it works but when I used SSIS Execute SQL task or OLEDB Source then it is giving me error:
No Connection manager is specified.
sql-server oracle replace plsql edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
I use UPDATE a SET GR_P = REPLACE(GR_P,'','') FROM mytable a to replace things.
But replace function is not working for below charter:
In Query analyzer it works but when I used SSIS Execute SQL task or OLEDB Source then it is giving me error:
No Connection manager is specified.
sql-server oracle replace plsql sql-server oracle replace plsql edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
edited Nov 14 '18 at 17:41
Raymond Chen
39.7k766111
39.7k766111
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
asked Nov 13 '18 at 0:52
Vivan_JVivan_J
36
36
What programming language is this?
– Raymond Chen
Nov 13 '18 at 2:05
not sure. This string character from RTF file.
– Vivan_J
Nov 13 '18 at 15:18
But what programming language is it? Is this MySQL?
– Raymond Chen
Nov 14 '18 at 0:30
PL/SQL. We are using sql server 2014.
– Vivan_J
Nov 14 '18 at 16:47
PL/SQLis Oracle.SQL Serveris Microsoft. If you're using the procedural extension of SQL Server, that'st-sql.
– Allan
Nov 14 '18 at 21:50
add a comment |
What programming language is this?
– Raymond Chen
Nov 13 '18 at 2:05
not sure. This string character from RTF file.
– Vivan_J
Nov 13 '18 at 15:18
But what programming language is it? Is this MySQL?
– Raymond Chen
Nov 14 '18 at 0:30
PL/SQL. We are using sql server 2014.
– Vivan_J
Nov 14 '18 at 16:47
PL/SQLis Oracle.SQL Serveris Microsoft. If you're using the procedural extension of SQL Server, that'st-sql.
– Allan
Nov 14 '18 at 21:50
What programming language is this?
– Raymond Chen
Nov 13 '18 at 2:05
What programming language is this?
– Raymond Chen
Nov 13 '18 at 2:05
not sure. This string character from RTF file.
– Vivan_J
Nov 13 '18 at 15:18
not sure. This string character from RTF file.
– Vivan_J
Nov 13 '18 at 15:18
But what programming language is it? Is this MySQL?
– Raymond Chen
Nov 14 '18 at 0:30
But what programming language is it? Is this MySQL?
– Raymond Chen
Nov 14 '18 at 0:30
PL/SQL. We are using sql server 2014.
– Vivan_J
Nov 14 '18 at 16:47
PL/SQL. We are using sql server 2014.
– Vivan_J
Nov 14 '18 at 16:47
PL/SQL is Oracle. SQL Server is Microsoft. If you're using the procedural extension of SQL Server, that's t-sql.– Allan
Nov 14 '18 at 21:50
PL/SQL is Oracle. SQL Server is Microsoft. If you're using the procedural extension of SQL Server, that's t-sql.– Allan
Nov 14 '18 at 21:50
add a comment |
1 Answer
1
active
oldest
votes
In Toad against Oracle (since that's one of your tags), I issued this (pressing ALT-12 to get the female symbol) and got 191 as a result. note selecting it back using CHR(191) shows an upside-down question mark though.
select ascii('♀') from dual;
Given that, this worked but it's Oracle syntax, your mileage may vary.
UPDATE mytable SET GR_P = REPLACE(GR_P, CHR(191));
Note if it does not work, that symbol could be for another control character. You may need to use a regular expression to eliminate all characters not in a-zA-Z0-9, etc. I suspect you'll need to update your tags to get a more accurate answer.
Maybe this info will help anyway. Please post back what you find out.
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
Thank you for your reply! I wrote procedure (with Replace Code) and called it in Execute SQL Task. That worked!! OLEDB Connection manager doesn't understand that character..
– Vivan_J
Nov 14 '18 at 22:20
If it worked for you please mark it as accepted for future searchers. Thanks, glad it helped.
– Gary_W
Nov 20 '18 at 20:47
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272217%2freplace-is-not-working-for-weird-character%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In Toad against Oracle (since that's one of your tags), I issued this (pressing ALT-12 to get the female symbol) and got 191 as a result. note selecting it back using CHR(191) shows an upside-down question mark though.
select ascii('♀') from dual;
Given that, this worked but it's Oracle syntax, your mileage may vary.
UPDATE mytable SET GR_P = REPLACE(GR_P, CHR(191));
Note if it does not work, that symbol could be for another control character. You may need to use a regular expression to eliminate all characters not in a-zA-Z0-9, etc. I suspect you'll need to update your tags to get a more accurate answer.
Maybe this info will help anyway. Please post back what you find out.
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
Thank you for your reply! I wrote procedure (with Replace Code) and called it in Execute SQL Task. That worked!! OLEDB Connection manager doesn't understand that character..
– Vivan_J
Nov 14 '18 at 22:20
If it worked for you please mark it as accepted for future searchers. Thanks, glad it helped.
– Gary_W
Nov 20 '18 at 20:47
add a comment |
In Toad against Oracle (since that's one of your tags), I issued this (pressing ALT-12 to get the female symbol) and got 191 as a result. note selecting it back using CHR(191) shows an upside-down question mark though.
select ascii('♀') from dual;
Given that, this worked but it's Oracle syntax, your mileage may vary.
UPDATE mytable SET GR_P = REPLACE(GR_P, CHR(191));
Note if it does not work, that symbol could be for another control character. You may need to use a regular expression to eliminate all characters not in a-zA-Z0-9, etc. I suspect you'll need to update your tags to get a more accurate answer.
Maybe this info will help anyway. Please post back what you find out.
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
Thank you for your reply! I wrote procedure (with Replace Code) and called it in Execute SQL Task. That worked!! OLEDB Connection manager doesn't understand that character..
– Vivan_J
Nov 14 '18 at 22:20
If it worked for you please mark it as accepted for future searchers. Thanks, glad it helped.
– Gary_W
Nov 20 '18 at 20:47
add a comment |
In Toad against Oracle (since that's one of your tags), I issued this (pressing ALT-12 to get the female symbol) and got 191 as a result. note selecting it back using CHR(191) shows an upside-down question mark though.
select ascii('♀') from dual;
Given that, this worked but it's Oracle syntax, your mileage may vary.
UPDATE mytable SET GR_P = REPLACE(GR_P, CHR(191));
Note if it does not work, that symbol could be for another control character. You may need to use a regular expression to eliminate all characters not in a-zA-Z0-9, etc. I suspect you'll need to update your tags to get a more accurate answer.
Maybe this info will help anyway. Please post back what you find out.
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
In Toad against Oracle (since that's one of your tags), I issued this (pressing ALT-12 to get the female symbol) and got 191 as a result. note selecting it back using CHR(191) shows an upside-down question mark though.
select ascii('♀') from dual;
Given that, this worked but it's Oracle syntax, your mileage may vary.
UPDATE mytable SET GR_P = REPLACE(GR_P, CHR(191));
Note if it does not work, that symbol could be for another control character. You may need to use a regular expression to eliminate all characters not in a-zA-Z0-9, etc. I suspect you'll need to update your tags to get a more accurate answer.
Maybe this info will help anyway. Please post back what you find out.
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
edited Nov 14 '18 at 21:52
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
answered Nov 14 '18 at 21:46
Gary_WGary_W
6,82811129
6,82811129
Thank you for your reply! I wrote procedure (with Replace Code) and called it in Execute SQL Task. That worked!! OLEDB Connection manager doesn't understand that character..
– Vivan_J
Nov 14 '18 at 22:20
If it worked for you please mark it as accepted for future searchers. Thanks, glad it helped.
– Gary_W
Nov 20 '18 at 20:47
add a comment |
Thank you for your reply! I wrote procedure (with Replace Code) and called it in Execute SQL Task. That worked!! OLEDB Connection manager doesn't understand that character..
– Vivan_J
Nov 14 '18 at 22:20
If it worked for you please mark it as accepted for future searchers. Thanks, glad it helped.
– Gary_W
Nov 20 '18 at 20:47
Thank you for your reply! I wrote procedure (with Replace Code) and called it in Execute SQL Task. That worked!! OLEDB Connection manager doesn't understand that character..
– Vivan_J
Nov 14 '18 at 22:20
Thank you for your reply! I wrote procedure (with Replace Code) and called it in Execute SQL Task. That worked!! OLEDB Connection manager doesn't understand that character..
– Vivan_J
Nov 14 '18 at 22:20
If it worked for you please mark it as accepted for future searchers. Thanks, glad it helped.
– Gary_W
Nov 20 '18 at 20:47
If it worked for you please mark it as accepted for future searchers. Thanks, glad it helped.
– Gary_W
Nov 20 '18 at 20:47
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272217%2freplace-is-not-working-for-weird-character%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What programming language is this?
– Raymond Chen
Nov 13 '18 at 2:05
not sure. This string character from RTF file.
– Vivan_J
Nov 13 '18 at 15:18
But what programming language is it? Is this MySQL?
– Raymond Chen
Nov 14 '18 at 0:30
PL/SQL. We are using sql server 2014.
– Vivan_J
Nov 14 '18 at 16:47
PL/SQLis Oracle.SQL Serveris Microsoft. If you're using the procedural extension of SQL Server, that'st-sql.– Allan
Nov 14 '18 at 21:50