Want to save the Semicolon (;) in Database through file data.

Want to save the Semicolon (;) in Database through file data.

  

Hi All,

   I am getting the error, While loading the data which has some special characters like semicolon(;). So while saving into DB i am facing the error. And the bellow is the error. I want to load that Semicolon also into my DB and the same has to show in UI also. I tried with ASCII values, But in DB it is storing as semicolon but in the UI it is showing ASCII value only.  Anyone has any idea to store the semicolon into DB. 



Hi Gopi,


Try replace ";" for "\:"


Fábio Vaz wrote:

Hi Gopi,


Try replace ";" for "\:"



Tried but still same issue. 

And this?

If you using an advance query

q'[ <your string> ]'

Hi Gopi,

I just try to to save semicolon in my text type data column and it working :

I added it from bootstrap process.

Can you attach oml , if u still facing issue.

Cheers,

Rocky

Fábio Vaz wrote:

And this?

q'[ <your string> ]'

Can u show one example with this ?


Gopi Dharmaraju wrote:

Fábio Vaz wrote:

And this?

q'[ <your string> ]'

Can u show one example with this ?


SET DEFINE OFF;
Insert into PROD_DESC(PROD_NO, PROD_DESC)
  Values ('XYZ', q'[test semicolon test; ]');


Rocky wrote:

Hi Gopi,

I just try to to save semicolon in my text type data column and it working :

I added it from bootstrap process.

Can you attach oml , if u still facing issue.

Cheers,

Rocky

INDUSTRIAS;  MANUFACTURERAS
ADM._PÚBLICA_Y_DEFENSA;_PLANES_DE_SEG._SOCIAL_AFILIACIÓN_OBLIGATORIA_CL

Above are my file data which i am trying to load. And i kept the variable type as text only. If possible can try to load this data.  



hi Gopi,

I try with your data everything working :


Rocky, 


He is using Oracle.

Rocky wrote:

hi Gopi,

I try with your data everything working :



Can you tel me the Version number of the outsystems which you are using ?

 less than 10 version it is taking but if u try on outsystems-10 it is thoroughgoing this error.

I m using outsystem 10 . :)