Home » Server Options » Streams & AQ » Queuing Arabic text (oracle 10g)
Queuing Arabic text [message #661700] Tue, 28 March 2017 12:15
dineshkumar18
Messages: 27
Registered: September 2016
Junior Member
When queuing the arabic text into the queue , it is getting inserted as ¿¿¿¿.

How ever when i try to insert the same into a table it is getting inserted as Arabic text.

   o_payload := queue_PushSMS_payload_Type_var(:NEW.Messagetext, 'Android', V_TOKEN,'CBQ Promotional SMS',:NEW.Notiid, :NEW.Messageid);
  
  DBMS_AQ.ENQUEUE(
        queue_name         => 'SMSII.PUSHSMS_queue_var',
        enqueue_options    => r_enqueue_options,
        message_properties => r_message_properties,
        payload            => o_payload,
        msgid              => v_message_handle
        );

insert into test.test_sms values(:NEW.Messagetext);

commit;


Here in the above code am able to see the arabic text in test.test_sms table but not in the queue.
Both are having the same datatype nvarchar2(2000)
Previous Topic: Ora-03113 in alert log for stream replication
Goto Forum:
  


Current Time: Thu Nov 23 10:57:04 CST 2017

Total time taken to generate the page: 0.01806 seconds