Using Oracle database with the encoding UTF-8

Question

I have an oracle database which is encoded to US-ASCII because when I run the command print db.encoding, US-ASCII is the response.

My problem is that I have some special characters in the database like "ç" and "ã" and when I make some queries, these special characters are returned as question marks (?).

I need to encode the data as UTF-8 but I don't know how. I've already used methods like encode() and unicode() but nothing works.

Can anyone help me please?

Thanks.

ePascoal · Accepted Answer · 2014-09-24 15:18:14Z

2

I've resolved my problem with the command below before the database connection:

import os
os.environ["NLS_LANG"] = ".UTF8"

answered Sep 24, 2014 at 15:18

ePascoal

2,4426 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shazin · Accepted Answer · 2014-09-24 05:31:43Z

0

You must create the database in Oracle with NATIONAL CHARACTER SET clause. Check this post on how to achieve this.

answered Sep 24, 2014 at 5:31

shazin

22k3 gold badges58 silver badges72 bronze badges

Collectives™ on Stack Overflow

Using Oracle database with the encoding UTF-8

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related