View Single Post
  #1 (permalink)  
Old 06-06-2007, 05:59 PM
bbq bbq is offline
Senior Member
 
Join Date: Jun 2007
Posts: 134
bbq is on a distinguished road
ñ in an oracle query
I have this problem when I try to execute this code:
Code:
String sql="SELECT DISTINCT M.AÑO_PERIODO_ACADEMICO_EST,NUM_SEM_PERIODO_ACAD_EST FROM CARRERA C,MATRICULA M,PERIODO_ACADEMICO P,ESTUDIANTE E WHERE C.CODIGO_ESTUDIANTE=? AND P.AÑO=M.AÑO_PERIODO_ACADEMICO_EST AND P.NUMERO=M.NUM_SEM_PERIODO_ACAD_EST AND E.TIPO_DOCUMENTO=C.TIPO_DOCUMENTO_EST AND E.NUMERO_DOCUMENTO=C.NUMERO_DOCUMENTO_EST AND C.TIPO_DOCUMENTO_EST=M.TIPO_DOCUMENTO_EST AND C.NUMERO_DOCUMENTO_EST=M.NUMERO_DOCUMENTO_EST AND ( m.COD_SITUACION_ACADEMICA_EST NOT IN ('C','G','F','S','T','P') OR m.COD_SITUACION_ACADEMICA_EST IS NOT NULL ) AND m.COD_SITUACION_ACADEMICA_EST!='T'"; prpStmt = connection.prepareStatement(sql); int i=1; prpStmt.setInt(i++,codigo_estudiante); resultSet = prpStmt.executeQuery();
But it returns me an error because of the character "ñ"
I need this ñ, I can't delete it, how can I fix that?
Reply With Quote
Sponsored Links