rsacramento Posted October 9, 2009 at 04:22 AM Report Share #290849 Posted October 9, 2009 at 04:22 AM uso Mysql5, java6 ao fazer esta query INSERT into registo (nomeUtilizador, palavraPasse, email, obs, site, url) VALUES ( 'mm' , ' mm' , 'mm ' , AES_ENCRYPT('mão', 'xpto' ) , 'mm', 'mm') e depois esta: SELECT nomeutilizador, palavrapasse, email, AES_DECRYPT( obs, 'xpto' ), site, url from registo where id = ? fica: ma� !!! o charset da coluna é latin1 como posso resolver isto? (nota: insiro, apago, actualizo e elimino sem problemas; mais - se não usar encriptação a palavra " mão" aparece tal e qual... obrigado antecipadamente Link to comment Share on other sites More sharing options...
M6 Posted October 12, 2009 at 12:38 PM Report Share #291338 Posted October 12, 2009 at 12:38 PM Experimenta usar UTF em vez de latin. 10 REM Generation 48K! 20 INPUT "URL:", A$ 30 IF A$(1 TO 4) = "HTTP" THEN PRINT "400 Bad Request": GOTO 50 40 PRINT "404 Not Found" 50 PRINT "./M6 @ Portugal a Programar." Link to comment Share on other sites More sharing options...
rsacramento Posted October 12, 2009 at 01:46 PM Author Report Share #291348 Posted October 12, 2009 at 01:46 PM já experimentei praticamente tudo, utf-8 incluído... mas nada Link to comment Share on other sites More sharing options...
M6 Posted October 12, 2009 at 03:36 PM Report Share #291362 Posted October 12, 2009 at 03:36 PM Começa por ver e usar um exemplo simples que encontres na documentação ou num tutorial. Depois testa com um charcode diferente, para despistares se o problema vem daí. 10 REM Generation 48K! 20 INPUT "URL:", A$ 30 IF A$(1 TO 4) = "HTTP" THEN PRINT "400 Bad Request": GOTO 50 40 PRINT "404 Not Found" 50 PRINT "./M6 @ Portugal a Programar." Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now