| Storing Special characters in the Database [message #52140] |
Thu, 04 July 2002 09:58  |
Sulaiman Gboyega N.
Messages: 17
Registered: April 2002
|
Junior Member |
|
|
Hi All,
I am confronted with this situation where I need to insert special characters in my database tables (characters with ASCII code between 0-255) and I am getting ORA-01756 quoted string not properly terminated.
I have taken steps in direction of setting NLS_LANG variable properly.
I set NLS_LANG on UNIX to WE8ISO8859P1 and
Recreated the database with NLS_CHARACTERSET WE8ISO8859P1, but still I could not insert these special characters.
Please Help, urgently.
Thank you all.
Sulaiman.
|
|
|
|
|
|
| Re: Storing Special characters in the Database [message #52155 is a reply to message #52149] |
Fri, 05 July 2002 04:21  |
Sulaiman Gboyega N.
Messages: 17
Registered: April 2002
|
Junior Member |
|
|
Thanks B. Unless I need to use a different syntax when I am inserting special characters, I did it the normal way I insert into a table.
Because I anticipate special characters, all datatypes are VARCHAR2.
I wanted to paste the actual statement here but the special characters didn't show. That's why I used abc,xyz,ft and ggg as placeholders for them.
There were no single quotes in the values as well.
INSERT INTO ENCRYPT_TEST ( GROUP_NAME, TABLENAME, PRIORITY, LOAD) VALUES ('abc', 'xyz', 'ft','ggg')
|
|
|
|
| Re: Storing Special characters in the Database [message #52187 is a reply to message #52149] |
Mon, 08 July 2002 04:16 |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
|
I know it's not a easy way to use, but did you try tou insert the character with the ASCII code ? You cans use 'select CHR(210) from dual;' to display the special character ASCII code 210 ( so you can also use it to insert special character 210 ). May be you should use sqlloader .... Or wait for someone with much experiences with special character .. Sorry...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
