Solved

Inverted Q'mark

Posted on 2002-07-16
12
308 Views
Last Modified: 2013-12-24
Hi there

can ne-one help me out with conversion of char into junk ... while inserting it in the oracle database.

I have a plain text - when I insert it thru my code - certain characters r converted to JUNK characters [inverted Q'mark] & inserted in the oracle DB.

has ne-one encountered this before.

if so pls help me out on this asap.

Awaiting

K'Rgds
Anand
0
Comment
Question by:anandkp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 5

Expert Comment

by:CFXPERT
ID: 7157146
Can we see your insert statement please?  This might help us to answer your question.
0
 
LVL 5

Expert Comment

by:CFXPERT
ID: 7157204
Also what is the Oracle datatype of the column in question here?
0
 
LVL 17

Author Comment

by:anandkp
ID: 7158670
Hi CFEXPERT,

this is my query. if i execute it from PLSQL - it converts [many chars in junk chars liek inverted q'mark].

if u ahve oracle as DB try inserting/updating this using a sql statement.


the data type can be either Varchar(4000) / CLOB. both of them give the same problem.

==============================

Update akp Set akp1 = 'Veelzijdig - super vrouwelijk - lief - scherp - goedlachs - prettig gestoord',akp2 = 'Wie ik ben en wat ik hier zoek??

Wie ik ben is me onderhand wel duidelijk!
Een leuke meid? Jammer dat lekker ding er niet tussen stond! ;))...
Veelzijdig – super vrouwelijk - lief - scherp – goedlachs – prettig gestoord – enthousiast – zacht – sterk – duidelijk - kritisch - adrem - diepgang – blablabla … :))
Zit lekker in mn velletje – heb lol in mn leventje en daarnaast nog een drukke job in de commerciele pharmacie.

Voor de lange mannen - ben 1.79 (incl. mijn onafscheidelijke hakken ;))
en de rest die minder lang is - troost je! - ben 1.72 op blote voetjes...
58 kilootjes licht - felle grijsblauwe ogen en lang blond haar.
En de rest - just ask! You*ll be surprised! :))

Maar wat ik hier zoek??
Een zaaddonor? Snelle wip? Sexchats?...No thnx!!!
Mijn hemel, moet ik hier dan iets zoeken of zoekende zijn?
Geen idee! ;))
Ik zie IwannaDate meer als een mogelijkheid om nieuwe mensen te leren kennen…

Desperate, hopeloos, wanhopig en grensoverschrijdend zoekende? Please doe mij een lol en jezelf een nog groter plezier en sla mij over! Heb aan zoenen en knuffels echt geen gebrek (pas 7.. maar desalniettemin .. :))

Verras me intussen maar met een origineel (!) mailtje … of leef je uit met een e-card…
x

Ben visueel ingesteld dus wil naast text ook het bijbehorend mannelijk schoon bewonderen. Voor een knipoog loop ik echt niet warm.. Laat staan dat ik de moeite neem om te reageren.
Jij wordt ook niet opgewonden van een pantykousje…

Jullie kicken ook (stiekem) op een foto van een lekker ding...ik ook!!

Nu nog Groningen - volgend jaar Zwolle…
' where akpID = 1

Awaiting !!
Anand
0
Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

 
LVL 5

Expert Comment

by:CFXPERT
ID: 7192390
What language Support do you have installed for PLSQL.  That seems to be your problem.  IT's not converting the characters correctly for you.

I would be using a differnt method than PLSQL.

0
 
LVL 17

Author Comment

by:anandkp
ID: 7192490
Hi CFXpert ...

Its got nothing to do with PLSQL. as i just view my tables using PLSQL ... so i dont think - that could be a reason.

there is langauge settings - ive tried that as well - but no luck yet.

ive also changed the LOCALE settings for CF - but still - NO LUCK ...

so if u know where exactly i should be checking for ... pls do let me know.

Thanx for all ur help

Waiting ...

K'Rgds
Anand
0
 
LVL 5

Expert Comment

by:CFXPERT
ID: 7194341
I will look into this a little more for you and try to figure out what might be happening and why.
0
 
LVL 17

Author Comment

by:anandkp
ID: 7195248
Hi CFXpert ...

Thanx ... I'll await ur comment on this ...

u can try executing thr query i have pasted above.

this query works - without ne-problem in SQl server, but with oracle - it gives strange results

pls let me know - if u can help me figure this one out !!!

Much appreciated,
Anand
0
 
LVL 2

Expert Comment

by:DBrown
ID: 7195361
Damn KK brushing up on your German eh!!
0
 

Expert Comment

by:nnb
ID: 7210953
Hi AKP,

U must have same language support on both the servers i mean cf server and oracle server. try using unicode- language support this supports almost all the charactes that a language can have in the world.  its a 32 bit code.

bye


nilesh
0
 

Accepted Solution

by:
nnb earned 100 total points
ID: 7210956
Hi AKP,

U must have same language support on both the servers i mean cf server and oracle server. try using unicode- language support this supports almost all the charactes that a language can have in the world.  its a 32 bit code.

bye


nilesh
0
 
LVL 17

Author Comment

by:anandkp
ID: 7213528
Hi nnb,

can u tell me how exactly do i go abt doing this ????

where should i set - "unicode- language"

pls advice ... awaiting ....

K'Rgds
Anand
0
 
LVL 17

Author Comment

by:anandkp
ID: 7972654
I guess that shld be it

sorry for the delayed response :)

Cheers
Anand
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question