MS Sql: select raw with special characters issue

QuestionsMS Sql: select raw with special characters issue
Stas asked 9 years ago

Hi,

I have an issue with select from MS Sql.

My query is:
$g->select_command = "SELECT MA.Description_59B77FD5_FE0E_D2B5_D541_0EBBD1EC9A2B FROM as Description [ServiceManager].[dbo].[MT_System$WorkItem$Activity$ManualActivity] as MA";

As result I got pop-up error without any text, just OK button.

I do not sure if I'm right but I think that issue is in values that are stored in 'Description_59B77FD5_FE0E_D2B5_D541_0EBBD1EC9A2B'. It can be ANY character like '"/` NEW_LINE@#$%^&*() etc.
Also there is more that 90k records in column and from 100 to 5000 characters per record.

Could you please help me?

If I do the same in this table but for other columns everything is fine. The only difference I see is character's number and column content (I mean characters like #$%^ etc)

1 Answers
Abu Ghufran answered 9 years ago

Please send me data of this table along with structure. (create and insert sql)
I'll try to generate same case here.

Your Answer

14 + 6 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?