Re: [cx-oracle-users] Accented character coming as "?" in select query output

[Anthony T. <ant...@gm...>]

Hi Johnny,

You need to make sure you are setting your NLS_LANG environment
variable correctly. If it is set to a character set that does not
support the characters you are trying to retrieve you will get
question marks. You can try querying through SQL*Plus first and
getting things working there. Once they are working there you should
be fine with cx_Oracle as well. There are other options available but
they are far more complicated and you need a good understanding of
character sets, encodings and the like. I would try setting NLS_LANG
first. :-)

Anthony

On Thu, Aug 9, 2012 at 12:23 PM, johnny jebaraj
<joh...@gm...> wrote:
> Hi All,
>
> I am new to Oracle as well as to cx_Oracle forum.
>
> Recently I installed cx_Oracle module in my Red Hat linux machine and tried
> to do some DB fetch[select] from oracle.
>
> Looks like the accented character from my Oracle table is being retrieved as
> ? symbol (or) replaced to another character, not sure what was the problem.
>
> Example:
>
> In DB                            --> output from python program
>
> Caché                           --> Cache
> Permian–Triassic           --> Permian?Triassic
>
> Did anyone faced this problem while using this module?
>
> I am using cx_Oracle-5.1.2 and Oracle 11g Database.
>
> Any help to solve this problem is very much appreciated.
>
> Thanks,
>
> Johnny
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>