Link to home
Start Free TrialLog in
Avatar of bincem
bincem

asked on

insert arabic text in oracle table ?

hi

 I am trying to pick an arabic values from one MS SQL table store that in an ORACLE table. But in oracle it shows as question marks.(??). this is query im using .

SQLQuery = "Insert into INVHDR(COMP_CODE)  values('" & ExpRecSet!briefNameArabic & "')

any helps!!

Avatar of MYLim
MYLim
you should use:
-NChar
-NVarchar
Avatar of MYLim
MYLim
1st. change your field type to NChar or NVarchar.
2nd.when insert to table,use 'N' + String like below:

SQLQuery = "Insert into INVHDR(COMP_CODE)  values(N'" & ExpRecSet!briefNameArabic & "')

EX:INSERT INTO UNicode_Table VALUES(1, N'Arabic_text');
Avatar of bincem
bincem

ASKER

hi mylim,

thanks for your reply.
but here situation is little different. I don't have the right to change the structure of oracle table. There the field type is 'varchar2'.

so any chances ??
ASKER CERTIFIED SOLUTION
Avatar of MYLim
MYLim
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leonstryker
leonstryker
Flag of United States of America image
bincem

Unless you can set the field in ORACLE to Nvarchar you will not be able to store unicode character sets in your ORACLE database.
Avatar of ayufans
ayufans
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- answered by MYLim

Please leave any comments here within the next four days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

ayufans
Cleanup Volunteer