"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
Dave Tolls wrote:But that's all the Oracle Thin driver does.
Translate from UTF-16 to UTF-8.
You haven't shown what data is causing the problem.
And you use q' in SQL Developer, but when you don't use it it fails to insert correctly?
"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
karthik Suryanarayanan wrote:
Exactly , when the prepared statement binds the query with actual data , it encloses the q quote within single quotes like ' q'[data]' ' and not as q'[data]'.
K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP
karthik Suryanarayanan wrote:
Dave Tolls wrote:But that's all the Oracle Thin driver does.
Translate from UTF-16 to UTF-8.
You haven't shown what data is causing the problem.
And you use q' in SQL Developer, but when you don't use it it fails to insert correctly?
Dear Dave,
I have shared below on what data is passed and how it is getting stored without using q quote operator.
Passed Data
âäàå
ëèïéë
Data getting Stored in DB
âäà å
ëèïéë
Dave Tolls wrote:
And for SQLDeveloper.
When you do:
INSERT INTO MAIL_TBL (<snip other fields> OD_MAIL_BODY <snip other fields>) values ('âäàå')
do you get âäà å in the database?
And when you do:
INSERT INTO MAIL_TBL (<snip other fields> OD_MAIL_BODY <snip other fields>) values (q'[âäàå]')
do you get âäàå in the database?
I'm trying to see whether all the bases have been covered here.
.
"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
karthik Suryanarayanan wrote:Dear Dave,
I finally found a solution. As you said , its not something to do with the q quote as it is unnecessary. The problem was with my String where the french data was in ISO-8859-1 encoding.
Hence , instead of passing my data directly for insert into DB , i did something like the below and it worked. Thanks !!!
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |