0

I cannot find functions to help me make an insert to interpret Spanish accents and characters like ñ. Can you lead me? Thanks

For example:

INSERT INTO PRUEBA.PRUEBA_EDAD(COD,DABREV,DCORTA,DLARGA,EDAD_MESES,EDAD_ANYOS,FECHA_ACT)
VALUES (60,'60','ENTRE 2 Y 8 AÑOS','ENTRE 2 Y 8 AÑOS',60,5,0,sysdate);
Justin Cave
  • 227,342
  • 24
  • 367
  • 384
Jorgechu
  • 143
  • 1
  • 1
  • 12
  • What kind of error do you get? What is your database character set? – Thilo Jul 03 '12 at 08:31
  • 3
    The [Globalization Support Guide PDF](http://docs.oracle.com/cd/E11882_01/server.112/e10729.pdf) is a 424 page document so you'll have to be more specific—not to mention that your problems (whatever they are) might be entirely on the client app side (whatever it is). – Álvaro González Jul 03 '12 at 08:43

1 Answers1

2

Can you explain exactly what the problem is? Are you getting replacement characters (either the ? or upside down ? most likely) when you query the data? Or something else?

  • What are the data types of the various columns (CHAR, VARCHAR2, etc.)?
  • What is the client NLS_LANG setting
  • What is the database server's database and national character set?

If you're not sure, you can run

SELECT *
  FROM v$nls_parameters
 WHERE parameter LIKE '%CHARACTERSET'
  • What language/ framework/ API are you using to issue the INSERT statement?
  • What do you get if you DUMP the data that is stored in the database

Something like

SELECT dump( DCORTA ) 
  FROM PRUEBA_EDAD
 WHERE cod = 60
Justin Cave
  • 227,342
  • 24
  • 367
  • 384