how to save data for a column which has nvarchar datatype using php oracle -


i want save unicode data in column defined nvarchar in oracle database :

"आवस्यकता है ड्राइवर्स की पूर्ण विवरण के साथ संपर्क करें - यादव (8000000008)"

but when run insert query in column nvarchar type in database.

¿¿¿¿¿¿¿¿ ¿¿ ¿¿¿¿¿¿¿¿¿ ¿¿ ¿¿¿¿¿ ¿¿¿¿¿ ¿¿ ¿¿¿ ¿¿¿¿¿¿ ¿¿¿¿ - ¿¿¿¿ (8000000008)

so question -> how save data column has nvarchar datatype using php oracle?

here trying do-

putenv("oracle_home=/u01/app/oracle/product/11.2.0/db_1"); putenv("ld_library_path=//u01/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib"); $conn = oci_connect('db1', 'ps1', '//xxx.xx.xx.xx:1521/orcl', 'al32utf8') or die('db not connected');       $stmt=oci_parse($conn,"insert tablenm (val1, val2, val3, val4, val5 )  values (:val1, :val2, :val3, :val4,  :val5 )");      $val1 = "jk";      $val2 = "10005072";      $val3 = "27-jul-17";      $val4 = 1;      $val5 = "आवस्यकता है ड्राइवर्स की पूर्ण विवरण के साथ संपर्क करें - यादव (8000000008)"; // val5 created datatype nvarchar in database        oci_bind_by_name($stmt, ':val1', $val1, 1000);        oci_bind_by_name($stmt, ':val2', $val2, 1000);        oci_bind_by_name($stmt, ':val3', $val3, 1000);        oci_bind_by_name($stmt, ':val4', $val4, 1000);        oci_bind_by_name($stmt, ':val5', $val5, 1000, sqlt_lbi);        $res =   oci_execute($stmt, oci_default);      oci_commit($conn);      echo "<pre>";      print_r($res);

i found sqlt_lbi here, not working me.

is there chances done?

please help!

neither php oci8 or pdo_oci support nvarchar, nchar or nclob types. page 149 of http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html still valid of now:

oracle's nchar, nvarchar2, , nclob types not supported in oci8 extension

there may odd environments works (?), might db character set width big enough hold db national character set.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more