Home » RDBMS Server » Server Administration » UPPERCASE with accent
UPPERCASE with accent [message #192491] Tue, 12 September 2006 10:37 Go to next message
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 Go to previous messageGo to next message
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
Re: UPPERCASE with accent [message #192784 is a reply to message #192502] Wed, 13 September 2006 09:48 Go to previous message
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
Previous Topic: Partition parameters (help needed)
Next Topic: dbms_stats - dbms_utility -analyze command : Differences?
Goto Forum:
  


Current Time: Fri Dec 09 21:34:24 CST 2016

Total time taken to generate the page: 0.04969 seconds