Hi,

I don't understand why oracle tells me this...

OCIParse: ORA-01756: quoted string not properly terminated

... When I try to insert a string with simple quote in this kind...

'bonjour, je m\'appelle Nicolas'

... And why doesn't it keep accent in the database? Table fields are Varchar2(1024), and form fields are transmitted by post method...

Do I have to prepare my strings before put them into a SQL query with oracle?

thanks

    • [deleted]

    • Post #2

    Maybe becuase Oracle does't use the backslash to escape characters.
    try using two single-quotes instead:

    'bonjour, je m''appelle Nicolas'

      thank you, now it works...

      But how come I can't get to keep trace of the accents?

      thanks again

        • [deleted]

        • Post #4

        Eh?

          I'm entering french words into my db, and so PHP gives SQL strings with accents, just like é, à, è, ô...
          And the when I'm displaying data, accents are gone. I've checked in the db with oracle client and they're missing!
          In my table, field type is varchar2(50).

          Maybe it's due to my version of oracle client, I think it's an english one.

          But I don't understand....
          see you

            Write a Reply...