OraFAQ Forum: Server Administration » UPPERCASE with accent

Home » RDBMS Server » Server Administration » UPPERCASE with accent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UPPERCASE with accent [message #192491]

Tue, 12 September 2006 10:37

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

Hi again friends

I´m trying to load specific characters but i have the follow message error.

ORA-01756: quoted string not properly terminated

The character that i´m loading are

�, �, �, �, the � doesn't have problems...

if i change them but their lowercase �, �, �, �. I don´t have any problem.... I´m using character set UTF8

I looked into for ascii and i can´t found something for these characters

SQL> select chr('224') from dual;

C
-

SQL> select chr('233') from dual;

C
-

SQL> select chr('144') from dual;

C
-
�

Can anybody help me?
Thanks to all
Alex

[Updated on: Tue, 12 September 2006 10:42]

Report message to a moderator

Re: UPPERCASE with accent [message #192502 is a reply to message #192491]

Tue, 12 September 2006 11:54

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

use set def off
and then run the insert commands it will work ..

-Sai Jeedigunta

Report message to a moderator

Re: UPPERCASE with accent [message #192784 is a reply to message #192502]

Wed, 13 September 2006 09:48

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

i changed my NLS LANG in the regedit and it works...

Thanks for help
ALex

Report message to a moderator

Previous Topic:	Partition parameters (help needed)
Next Topic:	dbms_stats - dbms_utility -analyze command : Differences?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:33:19 CDT 2024